I am trying to read data from a ODBC Connector Stage. Job design is simple with ODBC stage as source and sequential file as target. It runs fine for normally but when I turn on 'Enable Partition Reads' feature of ODBC Stage and give the table name & column name it throws following error.
The source table is a simple table on postgres database.
Apt configuration file details are there in the log below.
Please suggest.................................
...................................
Item #: 8
Event ID: 268
Timestamp:: 2007-10-25 18:36:57
Type: Info
User Name: dsadm
Message:: ODBC_Connector_0: [IIS-CONN-ODBC-000105] Connected to PostgreSQL, version 08.01.0200 PostgreSQL 8.2.4 (Greenplum Database 3.0.0.0-beta build 6 build ) on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4 through driver libpsqlodbc.so.
[IIS-CONN-DAAPI-000364] Generated SELECT statement: SELECT partkey,name,mfgr,brand,size,container,retailprice FROM manish_part3
Item #: 9
Event ID: 269
Timestamp:: 2007-10-25 18:36:57
Type: Info
User Name: dsadm
Message:: main_program: APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
{
node "node1"
{
fastname "greenplumbtest.persistent.co.in"
pools ""
resource disk "/opt/IBM/InformationServer/Server/Datasets" {pools ""}
resource scratchdisk "/opt/IBM/InformationServer/Server/Scratch" {pools ""}
}
}
Item #: 10
Event ID: 270
Timestamp:: 2007-10-25 18:37:05
Type: Info
User Name: dsadm
Message:: ODBC_Connector_0: [IIS-CONN-ODBC-000091] Before SQL command executed successfully
Item #: 11
Event ID: 271
Timestamp:: 2007-10-25 18:37:05
Type: Info
User Name: dsadm
Message:: ODBC_Connector_0,0: [IIS-CONN-ODBC-000105] Connected to PostgreSQL, version 08.01.0200 PostgreSQL 8.2.4 (Greenplum Database 3.0.0.0-beta build 6 build ) on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4 through driver libpsqlodbc.so.
[IIS-CONN-DAAPI-000364] Generated SELECT statement: SELECT partkey,name,mfgr,brand,size,container,retailprice FROM manish_part3
Item #: 12
Event ID: 272
Timestamp:: 2007-10-25 18:37:05
Type: Fatal
User Name: dsadm
Message:: ODBC_Connector_0,0: [IIS-CONN-DAAPI-000086] Partitioning trange too nerrow (0, 0) (CC_DBRecordDataSetProducer::modifySqlForRangePartitioning, file /builds/Common_Connectors/Build_Current/CC_Common/DAAPI/build/include/ccl/connector/CC_DBRecordDataSetProducer.inl, line 573)
Item #: 13
Event ID: 273
Timestamp:: 2007-10-25 18:37:05
Type: Fatal
User Name: dsadm
Message:: ODBC_Connector_0,0: The runLocally() of the operator failed.
Item #: 14
Event ID: 274
Timestamp:: 2007-10-25 18:37:05
Type: Info
User Name: dsadm
Message:: ODBC_Connector_0,0: Output 0 produced 0 records.
Item #: 15
Event ID: 275
Timestamp:: 2007-10-25 18:37:05
Type: Fatal
User Name: dsadm
Message:: ODBC_Connector_0,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
Item #: 16
Event ID: 276
Timestamp:: 2007-10-25 18:37:06
Type: Info
User Name: dsadm
Message:: Sequential_File_3,0: Export complete; 0 records exported successfully, 0 rejected.
Item #: 17
Event ID: 277
Timestamp:: 2007-10-25 18:37:11
Type: Fatal
User Name: dsadm
Message:: main_program: APT_PMsectionLeader(1, node1), player 2 - Unexpected exit status 1.
Item #: 18
Event ID: 278
Timestamp:: 2007-10-25 18:37:15
Type: Info
User Name: dsadm
Message:: ODBC_Connector_0: [IIS-CONN-ODBC-000092] After SQL command executed successfully
Item #: 19
Event ID: 279
Timestamp:: 2007-10-25 18:37:15
Type: Fatal
User Name: dsadm
Message:: main_program: Step execution finished with status = FAILED.
Item #: 20
Event ID: 280
Timestamp:: 2007-10-25 18:37:15
Type: Info
User Name: dsadm
Message:: main_program: Startup time, 0:21; production run time, 0:01.