Forum Discussion

Subbulakshmi's avatar
Subbulakshmi
Frequent Contributor
7 years ago

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. 
Database Error
  • Marsha_R's avatar
    Marsha_R
    Moderator
    7 years ago

    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.

     

     

     

     

    • Subbulakshmi's avatar
      Subbulakshmi
      Frequent Contributor
      7 years ago

      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.