DSXchange

Hi

I am seeing this error when trying column analysis.
... pxbridge: Error when checking operator: ??(IIS-CONN-ODBC-000004; ODBC function{0} reported: SQLSTATE=HY000: Native Error Code=1508: ...

Anybody knows what's the problem? how to fix it? (The data source I am using is text files via ODBC).

I searched and got this:

Error: 1508 SQLSTATE: HY000 (ER_DROP_LAST_PARTITION)
Message: Cannot remove all partitions, use DROP TABLE instead

Thanks in advance!

I checked the job log. It's the source data file permission issue.
The problem has been fixed!

thanks

mingzhang wrote:Hi

I am seeing this error when trying column analysis.
... pxbridge: Error when checking operator: ??(IIS-CONN-ODBC-000004; ODBC function{0} reported: SQLSTATE=HY000: Native Error Code=1508: ...

Anybody knows what's the problem? how to fix it? (The data source I am using is text files via ODBC).

I searched and got this:

Error: 1508 SQLSTATE: HY000 (ER_DROP_LAST_PARTITION)
Message: Cannot remove all partitions, use DROP TABLE instead

Thanks in advance!

Well done for finding the problem. Please mark the thread as Resolved using the green button at the top of the page.