pxbridge error during column analysis

[mingzhang]

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!

[mingzhang]

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

thanks

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!

[ray.wurlod]

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