Hi,
I am using Web Service Software Factiry July 2006 edition. I have
succflly created one small project with Client side imlementation. But While
Calling a service methid on pressing Save button on Client Form I am
receiving exceotuin as below.
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> Shiva.DataAccess.RepositoryFailureException: Unexpected error
occurred in the database server ---> System.Data.SqlClient.SqlException:
Procedure or function 'InsertShapeMst' expects parameter '@iD', which was not
supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand
command)
at Shiva.DataAccess.Repository`1.Add(IInsertFactory`1 insertFactory,
TDomainObject domainObj) in C:\Shiva\Source\Data Access
Layer\Shiva.DataAccess\Generic\Repository.cs:line 96
at Shiva.DataAccess.ShapeRepository.Add(Shape shape) in
C:\Shiva\Source\Data Access Layer\Shiva.DataAccess\ShapeRepository.cs:line 34
--- End of inner exception stack trace ---
at Shiva.DataAccess.ShapeRepository.HandleSqlException(SqlException ex,
IDbToBusinessEntityNameMapper mapper) in C:\Shiva\Source\Data Access
Layer\Shiva.DataAccess\ShapeRepository.cs:line 60
at Shiva.DataAccess.ShapeRepository.Add(Shape shape) in
C:\Shiva\Source\Data Access Layer\Shiva.DataAccess\ShapeRepository.cs:line 38
at Shiva.BusinessLogic.AddShape.RegisterShape(Shape shape) in
C:\Shiva\Source\Business Component\Shiva.BusinessLogic\AddShape.cs:line 14
at Shiva.ServiceImplementation.ShapeService.AddNewShape(ShapeInfoRequest
AddNewShapeRequest) in
C:\Shiva\Source\Service\Shiva.ServiceImplementation\ShapeService.cs:line 33
--- End of inner exception stack trace ---
I am facing this trouble since long time Please anyone Who can
help me to solve this issue.
Nilkanth Desai
