Ask a Question

Getting EDatabase Error randomly while executing VBScript code

Subbulakshmi
Frequent Contributor

Getting EDatabase Error randomly while executing VBScript code

Hi,

 

In our execution we need to fetch some data from database and enter the value in Grid view(Delphi application). While doing this, I am getting the below error randomly. 

 

VBScript runtime error. An exception occurred: 0x0EEDFADE; class: EDatabaseError; description: 'There was a serious system error.YN 26/03/2018 14:21:43 User: ITVPLC deepsubb Server: YWAST057 Database ID: 1 Database Name: itvtestauto Last Upgrade Token: 2.31 02/03/2018 15:00:52 Version: 2.31.015.006 Function Name: Exception: EDatabaseError Invalid value for field 'Sales Area' System Error Code: Not known Stack trace: Physical Logical Unit (######) Routine 00479E0D 00078E0D DB.DB.DatabaseError 00479E82 00078E82 DB.DB.DatabaseErrorFmt 0047DF11 0007CF11 DB.DB.TField.SetAsVariant 00A5392F 0065292F cxDB.cxDB.SetFieldValue 0075A9C8 003599C8 cxCustomData.cxCustomData.TcxCustomDataController.SetEditValue 009FB061 005FA061 cxGridCustomTableView.cxGridCustomTableView.TcxCustomGridTableItem.SetEditValue' Error location: Unit: "ITV_TestAutomation_Framework\DealTestSuite\Script\TestDummy" Line: 554 Column: 3.

VBScript runtime error.

An exception occurred: 0x0EEDFADE; class: EDatabaseError; description: '<ErrorInfo><Error number="11043"><EMessage>There was a serious system error.</EMessage><ELog>Y</ELog><EServer>N</EServer><ELoggedMessage>

26/03/2018 14:21:43
User: ITVPLC deepsubb
Server: YWAST057
Database ID: 1
Database Name: itvtestauto
Last Upgrade Token: 2.31 02/03/2018 15:00:52
Version: 2.31.015.006
Function Name:
Exception: EDatabaseError
Invalid value for field 'Sales Area'
System Error Code: Not known
Stack trace:
Physical Logical  Unit                (######) Routine
00479E0D 00078E0D DB.DB.DatabaseError
00479E82 00078E82 DB.DB.DatabaseErrorFmt
0047DF11 0007CF11 DB.DB.TField.SetAsVariant
00A5392F 0065292F cxDB.cxDB.SetFieldValue
0075A9C8 003599C8 cxCustomData.cxCustomData.TcxCustomDataController.SetEditValue
009FB061 005FA061 cxGridCustomTableView.cxGridCustomTableView.TcxCustomGridTableItem.SetEditValue</ELoggedMessage><EFormName></EFormName></Error></ErrorInfo>'

Error location:
Unit: "FileName\DealTestSuite\Script\TestDummy"
Line: 554 Column: 3.
 
 
I have closed DB Connection properly. 
Regards,
Subbulakshmi
3 REPLIES 3
Marsha_R
Community Hero

Re: Getting EDatabase Error randomly while executing VBScript code

While doing this, I am getting the below error randomly. 

While doing what?  You didn't show us any code.  And how often is "randomly"?  Every time, every other time, once a week?

 

Error Invalid value for field 'Sales Area'

Is all your data valid?  Check the row of data where the failure occurred and make sure "Sales Area" has a good value.  Try a simple query that would give you this row and display "Sales Area" and see if that fails.

 

 

 

 


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
Subbulakshmi
Frequent Contributor

Re: Getting EDatabase Error randomly while executing VBScript code

I am trying to print the value returned from function which reads DB value and even though it is printed properly in function, it is not returning anything here. I am checking the same. 

Regards,
Subbulakshmi
Marsha_R
Community Hero

Re: Getting EDatabase Error randomly while executing VBScript code

Show us the code please.


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
cancel
Showing results for 
Search instead for 
Did you mean: