Hello Experts,

I have DBA created a new Oracle table MRS_VEH_FIELDHIST (see attachment  new_table_MRS_VEH_FIELDHIST.png). it is the first new table since this application is in service. 

but this table is not accessible in the EGL program.  the error is in the attachment Tomcat_output_Error.docx,

EGL0504E OPEN: ORA-00942: table or view does not exist
[sqlstate:42000][sqlcode:942]

The schema mrsveh is the default schema. The EGL program is in VHCL02C.docx,  please check the function at line Function VHCL02CQ_GETMODIFIED (), 

in this file I have sysLib.writeStdout  statements to track the process.  it is the only way to debug. application is developed by a contractor, the debug is not available.

Could you help teach me why the new table is not accessible? Is there a file hard copied the data tables to be used? but I search, cannot find it.

Thanks in advance,

Eric

Attachment(s)

VHCL02C.docx   25 KB 1 version

Tomcat_output_Error.docx   13 KB 1 version

Hi Mark,

Thank you for your reply.  Our application is developed by  an out-source, they customized the EGL. the text box, label, Exception, etc, are all rewriten, but no document released. the sqlreord too.  Eventually I fixed it. 

Original Message:
Sent: Fri March 22, 2024 08:07 AM
From: Mark Hall
Subject: Cannot Access a new database table

Hi Eric,

 

Good afternoon, I would advise to create a support ticket wherever possible where it involves application errors so that my support team can investigate fully, join you in a web session etc.

However I took a quick look at your code and I do not see the CHANGEDATE column defined within your record entry ie:

Record VHCL02C@BRT_MODIFIED type sqlRecord

    { tableNames = [ [ "MRS_VEH_FIELDHIST", "T1" ] ] }

    3 CAR_NO char(4) { column = "T1.CAR_NO", isSQLNullable = yes };

    3 MODIFIED char(1) { column = "T1.MODIFIED", isSQLNullable = yes };  

    3 DATETIMEINSRV char(19) { column = "DATETIMEINSRV", isSQLNullable = yes };   

end

You can manually add it or use our SQL Retrieve option which will automatically add your columns to the table definition ie

Record VHCL02C@BRT_MODIFIED type sqlRecord

    { tableNames = [ [ "MRS_VEH_FIELDHIST", "T1" ] ] }

    

 Right click -> SQL Record -> Retrieve SQL

   

end

Hopefully that helps you resolve your error, if not once again I recommend creating a ticket where I would be happy to join you in a web session to walk through it.

Thanks and Regards

Mark 

 

Mark Hall

HCL Technologies

RBD L2 Support

------------------------------
Mark Hall
------------------------------