JQL SQL conversion in when running an Enquiry

  • lkourbali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #20732 by lkourbali
Hello T24ALL,

I've this error after running an LD L L (with @ID LK LD...)
[ERROR] 2016-12-16 09:46:30,770 [EX_117801658] DATABASE - SSELECT FBNK.LD.LOANS.AND.DEPOSITS$NAU WITH @ID LIKE "'LD'..." : Failed to execute statement : 'SELECT RECID FROM "FBNK_LD_LOANS_AND_D000" WHERE TO_NUMBER(RECID) LIKE ? ORDER BY RECID' ORA-01722: invalid number

Is accept that the problem is coming from the TO_NUMBER oracle function. I tried it with TT, FT the TO_NUMBER is not invocated and the Enquiries are running properly. The issue is happening also when it's ran from Browser.

Framework: TAFJ SP3
DB: Oracle12C
AS: JBOSS

Regards.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
7 years 5 months ago - 7 years 5 months ago #20733 by VK
Hi
Maybe because (in my system at least) TT and FT have "L" formatting for @ID in the dictionary and LD has "25R". "R" formatting is usually interpreted as a numeric in T24.

Cheers
VK
Last edit: 7 years 5 months ago by VK.

Please Log in or Create an account to join the conversation.

  • lkourbali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #20734 by lkourbali
Replied by lkourbali on topic JQL SQL conversion in when running an Enquiry
Just tried with 25L, not it's not working...

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
7 years 5 months ago #20735 by VK
You corrected the dictionary directly?

Cheers
VK

Please Log in or Create an account to join the conversation.

  • lkourbali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #20737 by lkourbali
Replied by lkourbali on topic JQL SQL conversion in when running an Enquiry
Yes, In a local environment, but it's not a real solution as for each rebuild of the SS the actual data are getting back

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
7 years 5 months ago #20742 by VK
Hi
I didn't say it might be a real solution :))) The real solution would be to force Temenos to admit that it's their error; SS should be corrected by them.

Cheers
VK
The following user(s) said Thank You: lkourbali

Please Log in or Create an account to join the conversation.

  • lkourbali
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #20880 by lkourbali
Replied by lkourbali on topic JQL SQL conversion in when running an Enquiry
Problem Solved, related to the TAFJ Version ...

Please Log in or Create an account to join the conversation.

Time to create page: 0.081 seconds