| Debug error [message #1837130] |
Fri, 22 January 2021 14:01 |
 Blaz Rakar
Messages: 3
Registered: January 2021 |
Junior Member |
|
|
Hello, I have question about BIRT Designer.
When I run BIRT report I get erorrs like this :
DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=3.69.71
I get error because of this cases select:
+ " case WHEN MXZINVTRANS.TOSTORELOC IS NULL "
+ " THEN case "
+ " WHEN MXZINVTRANS.TRANSTYPE_DESCRIPTION='Ident prejema' OR MXZINVTRANS.TRANSTYPE_DESCRIPTION='Ident vračila' "
+ " THEN (select distinct VENDOR from PO where PO.PONUM=MXZINVTRANS.DOCUMENT) " //izberemo ŠTEVILKO DOBAVITELJA
+ " WHEN MXZINVTRANS.TRANSTYPE_DESCRIPTION='Izdaja' OR MXZINVTRANS.TRANSTYPE_DESCRIPTION='Vračilo'"
+ " THEN case WHEN MXZINVTRANS.DOCUMENT LIKE '%-%' AND MXZINVTRANS.REFDOC LIKE '%-%' " // pogledamo, če se nahaja znak '-'
+" THEN (select distinct LOCATION from INVUSELINE where left(MXZINVTRANS.REFDOC, LOCATE('-',MXZINVTRANS.REFDOC)-1)=INVUSELINE.INVUSENUM AND INVUSELINE.ITEMNUM=MXZINVTRANS.ITEMNUM AND INVUSELINE.FROMSTORELOC=MXZINVTRANS.STORELOC) " //izberemo levo stran stringa (#številka izdajnice) //izberemo levo stran stringa (#številka izdajnice)
+ " ELSE MXZINVTRANS.DOCUMENT " // številka delovnega naloga
+ " END "
+ " END "
+ " ELSE "
+ " MXZINVTRANS.TOSTORELOC "
+ " END "
+ " AS TOSTORELOC"
The problem is here
+" THEN (select distinct LOCATION from INVUSELINE where left(MXZINVTRANS.REFDOC, LOCATE('-',MXZINVTRANS.REFDOC)-1)=INVUSELINE.INVUSENUM AND INVUSELINE.ITEMNUM=MXZINVTRANS.ITEMNUM AND INVUSELINE.FROMSTORELOC=MXZINVTRANS.STORELOC) "
So here because of this LOCATE --> left(MXZINVTRANS.REFDOC, LOCATE('-',MXZINVTRANS.REFDOC)-1)=INVUSELINE.INVUSENUM
+ " THEN '#' || left(MXZINVTRANS.DOCUMENT, LOCATE('-',MXZINVTRANS.DOCUMENT)-1) "
In MXZINVTRANS.REFDOC are datas like this '
37373-1-TVD11'
but I get error anyway, if I hardcode this and insted MXZINVTRANS.REFDOC gave '
37373-1-TVD11' there are no problems.
Any solution for this?
Attachment: pic.png
(Size: 80.98KB, Downloaded 68 times)
|
|
|
Powered by
FUDForum. Page generated in 0.02899 seconds
] 
Search
Help
Register
Login
Home
