XSD issue in virtual table creation

[ray.wurlod]

Looks like you have have left 'Apple' unquoted, or quoted it with double quotes rather than single quotes, so that DB2 believes it to be a column name.

[rjdickson]

MJ,

Start simple, add one thing at a time in, and you will know what caused the issue and can work from there.

This does work. I've done it as recently as 10 minutes ago.

Good luck!

[Maximus_Jack]

yes, did that robert and ray, adding one by one, all these logs where found in iaserver.log

COL1 = 'APPLE' ---> No problem when put in single quotes

when validated only with this condition
END_DATE > DATE()

error received:
Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.

com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)

when validated only for
BEGINDATE <= DATE()

received error as:
Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.

com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)

when validated only for
DATEVAL(EFDATE)

received error as:
Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL

com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)

[rjdickson]

ok - good. We are making some progress.

I see that you are using DB2/Z. DATE() apparently does not work for you. It works for me because I am using an ODBC source.

Maybe CURRENT_DATE() instead?

[Maximus_Jack]

tried both robert

END_DATE > CURDATE()

CURDATE

Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE

com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)


BEGINDATE <= CURRENT_DATE()

CURRENT_DATE

Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE

com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)

according to this doc, curdate() should have worked, but not working.. know why???

http://pic.dhe.ibm.com/infocenter/dzich ... clidat.htm

[rjdickson]

Two more thoughts:

Code: Select all

Try END_DATE > CURDATE() AND COL1 = 'APPLE'

() is not the last thing one the line. Just a silly guess as I don't have a DB2 Z system to test with...

If that does not work, then open a PMR with JUST 'END_DATE > CURDATE() not working.'

Good luck!

[Maximus_Jack]

any insights on this please? thanks