Same error when I tried through management portal.

[SQLCODE: <-415>:<Fatal error occurred within the SQL filer>]

[%msg: <Error occurring during UPDATE in table 'SQLUser.PA_Person': $ZE=<LIST>%SQLUpdate+40^User.PAPerson.1>]

Update SQLUser.PA_Person set PAPER_REMARK = PAPER_REMARK ||'abc'   where PAPER_PAPMI_DR->PAPMI_No='1111' and PAPER_ROWID='2222'
 

I tried using management portal and I got this error below.

[SQLCODE: <-415>:<Fatal error occurred within the SQL filer>]

[%msg: <Error occurring during UPDATE in table 'SQLUser.PA_Person': $ZE=<LIST>%SQLUpdate+40^User.PAPerson.1>]

Please see the win sql result but its not updating

This is not working . When I running through win sql , It shows '[%' but not updating.

This is not working . When I running through win sql , It shows '[%' but not updating.

Its not working in Update query .

  Update tablename set column1 = {fn CONCAT('column1, ' world')} where ....

Is it something like this ?
 

Hi ,  Trakcare is not sending parameter to Jreport . This is causing the issue.

I don't think this is a solution for the question. Also trakcare have its own date parameter specification.

Thanks

Hi Timo, Could you please where to set up the path on Trakcare for Jreport. I can see only on Report manager . Do we need to make any paths on configuration manager ?

Thanks

Hi ,  I set up the environment variables including the Java_ home and class path but still its showing the above error.

Thanks

I tried to use the Save To command but I am getting an error as shown in the screen shot attached. Could you

please tell me how to solve this error.

This is the way how I use to_char in sql statement

TO_CHAR(58105,'DDMMYYYY')

I am extracting the data to excel file and I can see the column is assigned as a General and not a number. does it make any difference ?

Thanks

Hi Ben, This is not working fully. I mean to say MM is displaying with 0 but DD is not displaying with 0.

For instance, it displays as 1082000 and it should be 01082000.

Thanks

Jude

Please find the ODBC error below.

2023-07-24 02:05:48 [SQLCODE: <-400>:<Fatal error occurred>] [Error: <<READ>ServerLoop+18^%SYS.DBSRV>] [Location: <ServerLoop>] [Client info: <Username: , Node Name:  IP Address: , Executable Name: , Internal Function: DQ>] [%protocol: <57>] $Id: //adhocs-iris/2020.1.0.215.0/TRAKCARE_001/kernel/common/src/aclass.c#1 $ 24006 0

.

Hi @Luis Angel Pérez Ramos 
                                             , I tried that option but still It got failed.

Any other advise ?

Thanks

Hi @Robert Cemper ,
They are running the queries in a serial mode , ie one after the other. They are using this to load data into SSIS database. But once they reach some of the tables , it will show this error.  This is running fine for 150 tables but the error is showing only for 10 tables.

Hi @Luis Angel Pérez Ramos 
                                             , I tried that option but still It got failed.

Any other advise ?

Thanks

Still the issue exist .Its not pool connection issue.

Could you please check what I did is correct ?

thanks

Which format do you want ? 

Yes. Since it’s a long query , I don’t have an option to include a sub query. 

Thanks

Extract data from cache db. Need to run the sql query.