I am writing a vb.net autoprocess using Sybase ASE 12.5.2. Therough the
program i am trying to insert certain data into a sybase table through
a stored procedure.
The problem is when i execute the stored procedure from back end with
same values thats getting passed through parameters from the vb.net
autoprocess, it gets executed without any error. But through vb.net
autoprocess for the same stored procedure execution i get the following
error
Message "Internal Error: 30002"
Source "Sybase.Data.AseClient"
StackTrace " at Sybase.Data.AseClient.AseCommand.CheckResult(Int32
res)
at Sybase.Data.AseClient.AseCommand.Execute()
at Sybase.Data.AseClient.AseCommand.ExecuteNonQuery()
at EDIDataLayer.DataManager.SybaseDBManager.RunProced ure(String
storedProcName, IDataParameter[]& parameters, Int32& rowsAffected,
String tableName) in F:\Sowmya\CT-WCS\VSS\Project Development\Source
Code\CT_WCS_FRIS_EDI\EDIDataLayer\SybaseDBManager. vb:line 153
at EDIDataLayer.CT_WCS_FRIS_EDIDAL.EDIDAL.InsertFROI( Int32
intHdrTranNbr, String strTranSetID, String strMaintTypeCd, String
strMtc_Dte, String strJurisdiction, String strAgncyClaimNum, String
strInsFein, String strInsName, String strAdmFein, String strAdmName,
String strAdmAddress1, String strAdmAddress2, String strAdmCity, String
strFkAdmStaCd, String strAdmZipCode, String strInsClaimNum, String
strEmrFein, String strInsuredName, String strEmrName, String
strEmrAddress1, String strEmrAddress2, String strEmrCity, String
strFkEmrStaCd, String strEmrZipCode, String strSelfInsuredInd, String
strFkSicNum, String strInsuredReportNum, String strInsuredLocationNum,
String strPolicyNum, String strPolicyEffectiveDt, String
strPolicyExpireDate, String strInjuryDate, String strTimeOfInjury,
String strFkInjuryZipCd, String strInjEmrPremisesInd, String
strFkIjnNum, String strFkBptNum, String strFkIjcNum, String
strDescrOfInjury, String strFkItmNum, String strDtEmployerNotified,
String strDateAdminNotified, String strSocialSecNo, String
strEmpLastName, String strEmpFirstName, String strEmpMiddleInitial,
String strEmpAddress1, String strEmpAddress2, String strEmpCity, String
strFkEmpStaCd, String strEmpZipCode, String strEmpPhone, String
strDateOfBirth, String strGender, String strMaritalStatus, String
strNoofDependents, String strDtDisabilityBegan, String strDateOfDeath,
String strFkEstCd, String strClassCode, String strFkOccNum, String
strDateOfHire, String strGrossWages, String strFkWprCd, String
strDaysWorkedWeekly, String strLastWorkDate, String
strFullPayInjDayInd, String strSalaryContinueInd, String
strDateReturnedWork, String strSubmissionType, Int32 intEDIStatus,
Int32& intFRINumOut) in F:\Sowmya\CT-WCS\VSS\Project Development\Source
Code\CT_WCS_FRIS_EDI\EDIDataLayer\EDIDAL.vb:line 804"

The assembly information is :
AssemblyQualifiedName "Sybase.Data.AseClient.AseCommand,
Sybase.Data.AseClient, Version=1.1.327.0, Culture=neutral,
PublicKeyToken=26e0f1529304f4a7"

I am not able to find any solution for this...Can anyone through some
light on this....Hoping to get the solution ASAP....

Sowmya

Hi, go thro' the below link it is useful for you.

http://www.pfcguide.com/_newsgroups/...ivity%2Eadonet

regards,
Maris


sgaikwad@hcltmass.com wrote:
> I am writing a vb.net autoprocess using Sybase ASE 12.5.2. Therough the
> program i am trying to insert certain data into a sybase table through
> a stored procedure.
> The problem is when i execute the stored procedure from back end with
> same values thats getting passed through parameters from the vb.net
> autoprocess, it gets executed without any error. But through vb.net
> autoprocess for the same stored procedure execution i get the following
> error
> Message "Internal Error: 30002"
> Source "Sybase.Data.AseClient"
> StackTrace " at Sybase.Data.AseClient.AseCommand.CheckResult(Int32
> res)
> at Sybase.Data.AseClient.AseCommand.Execute()
> at Sybase.Data.AseClient.AseCommand.ExecuteNonQuery()
> at EDIDataLayer.DataManager.SybaseDBManager.RunProced ure(String
> storedProcName, IDataParameter[]& parameters, Int32& rowsAffected,
> String tableName) in F:\Sowmya\CT-WCS\VSS\Project Development\Source
> Code\CT_WCS_FRIS_EDI\EDIDataLayer\SybaseDBManager. vb:line 153
> at EDIDataLayer.CT_WCS_FRIS_EDIDAL.EDIDAL.InsertFROI( Int32
> intHdrTranNbr, String strTranSetID, String strMaintTypeCd, String
> strMtc_Dte, String strJurisdiction, String strAgncyClaimNum, String
> strInsFein, String strInsName, String strAdmFein, String strAdmName,
> String strAdmAddress1, String strAdmAddress2, String strAdmCity, String
> strFkAdmStaCd, String strAdmZipCode, String strInsClaimNum, String
> strEmrFein, String strInsuredName, String strEmrName, String
> strEmrAddress1, String strEmrAddress2, String strEmrCity, String
> strFkEmrStaCd, String strEmrZipCode, String strSelfInsuredInd, String
> strFkSicNum, String strInsuredReportNum, String strInsuredLocationNum,
> String strPolicyNum, String strPolicyEffectiveDt, String
> strPolicyExpireDate, String strInjuryDate, String strTimeOfInjury,
> String strFkInjuryZipCd, String strInjEmrPremisesInd, String
> strFkIjnNum, String strFkBptNum, String strFkIjcNum, String
> strDescrOfInjury, String strFkItmNum, String strDtEmployerNotified,
> String strDateAdminNotified, String strSocialSecNo, String
> strEmpLastName, String strEmpFirstName, String strEmpMiddleInitial,
> String strEmpAddress1, String strEmpAddress2, String strEmpCity, String
> strFkEmpStaCd, String strEmpZipCode, String strEmpPhone, String
> strDateOfBirth, String strGender, String strMaritalStatus, String
> strNoofDependents, String strDtDisabilityBegan, String strDateOfDeath,
> String strFkEstCd, String strClassCode, String strFkOccNum, String
> strDateOfHire, String strGrossWages, String strFkWprCd, String
> strDaysWorkedWeekly, String strLastWorkDate, String
> strFullPayInjDayInd, String strSalaryContinueInd, String
> strDateReturnedWork, String strSubmissionType, Int32 intEDIStatus,
> Int32& intFRINumOut) in F:\Sowmya\CT-WCS\VSS\Project Development\Source
> Code\CT_WCS_FRIS_EDI\EDIDataLayer\EDIDAL.vb:line 804"
>
> The assembly information is :
> AssemblyQualifiedName "Sybase.Data.AseClient.AseCommand,
> Sybase.Data.AseClient, Version=1.1.327.0, Culture=neutral,
> PublicKeyToken=26e0f1529304f4a7"
>
> I am not able to find any solution for this...Can anyone through some
> light on this....Hoping to get the solution ASAP....
>
> Sowmya