hi
I am facing a serious issue when I am designing my job, using the TPT connector at source level, I am trying to push the data and I am getting warning and error messages like this.
Warning:
Teradata Connector : IIS-CONN-DAAPI-----67 - Schema Reconcilation detected a size msimatch for field , XXXXX. When moving data from source field type USTRING(min=0,max=5) into target field type(.....)
Fatal:
Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to framework type int32 (CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813)[/b][/b]
Datastage : teradata connector TPT stage erorr message
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
It sounds like a bug. You should report the problem to IBM support.
The connector calls setUnscaledByte in cases where you are selecting a DECIMAL column that has a length of only 1 byte, i.e. a DECIMAL(1) or DECIMAL(2). As a work around, you could try casting the column to an INTEGER or a larger decimal. e.g.
SELECT CAST(DecimalColumnName AS DECIMAL(5)) FROM TableName
The connector calls setUnscaledByte in cases where you are selecting a DECIMAL column that has a length of only 1 byte, i.e. a DECIMAL(1) or DECIMAL(2). As a work around, you could try casting the column to an INTEGER or a larger decimal. e.g.
SELECT CAST(DecimalColumnName AS DECIMAL(5)) FROM TableName
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
Fatal msg is not yet resoloved.
Hi,
Able to resolove the warning message but could not able to resolve FATAL message.
Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813)
Tried in multiple ways like, by casting at the source levels
unable to find out when exactly this msg is coming, primarily coming for Decimal and Timestamp meta data types.
Throwing the same message even after casting at the source levels while extracting.
But the same SQL is working correctly at the DB level but not from TPT.
Please reply if anyone got solution for this.
Thanks,
friend.kak@gmail.com
Able to resolove the warning message but could not able to resolve FATAL message.
Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813)
Tried in multiple ways like, by casting at the source levels
unable to find out when exactly this msg is coming, primarily coming for Decimal and Timestamp meta data types.
Throwing the same message even after casting at the source levels while extracting.
But the same SQL is working correctly at the DB level but not from TPT.
Please reply if anyone got solution for this.
Thanks,
friend.kak@gmail.com
- Dev
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
Fatal msg is not yet resoloved.
Hi,
Able to resolove the warning message but could not able to resolve FATAL message.
Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813)
Tried in multiple ways like, by casting at the source levels
unable to find out when exactly this msg is coming, primarily coming for Decimal and Timestamp meta data types.
Throwing the same message even after casting at the source levels while extracting.
But the same SQL is working correctly at the DB level but not from TPT.
Please reply if anyone got solution for this.
Thanks,
friend.kak@gmail.com
Able to resolove the warning message but could not able to resolve FATAL message.
Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813)
Tried in multiple ways like, by casting at the source levels
unable to find out when exactly this msg is coming, primarily coming for Decimal and Timestamp meta data types.
Throwing the same message even after casting at the source levels while extracting.
But the same SQL is working correctly at the DB level but not from TPT.
Please reply if anyone got solution for this.
Thanks,
friend.kak@gmail.com
- Dev