Web Service Software Factory Problem

[Nilkanth Desai]

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(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand command)
at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.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.HandleSqlExceptio n(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.AddNewSha pe(ShapeInfoRequest
AddNewShapeRequest) in
C:\Shiva\Source\Service\Shiva.ServiceImplementatio n\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

[Pablo Cibraro [MVP]]

Hi,

There is an error in your data layer. You are trying to execute a store
procedure "InsertShapeMst" in SQL Server, but you are not proving the right
parameters to execute it (You need to provide a value for the parameter @iD.
in the store procedure)

Regards,
Pablo Cibraro.
"Nilkanth Desai" <Ni***********@discussions.microsoft.comwrote in message
news:3C**********************************@microsof t.com...

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(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader
ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.DoExecuteNonQuery(DbCommand
command)
at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.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.HandleSqlExceptio n(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.AddNewSha pe(ShapeInfoRequest
AddNewShapeRequest) in
C:\Shiva\Source\Service\Shiva.ServiceImplementatio n\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