TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file or directory'

Tools & Utilities
Teradata Employee

TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file or directory'

Hi Folks,

 

I am trying to investigate an error which one of the developers is facing at the client site.

 

The TPT job keeps failing with the error message - TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file: No such file or directory'.

 

The TPT version is Teradata Parallel Transporter Version 15.10.01.06 64-Bit.

 

I can see the file lib_Ticu27.so in the following two locations -
/applic/Teradata15/teradata/client/15.10/tbuild/odbc/lib
/applic/Teradata15/teradata/client/15.10/tbuild/odbc/lib64

 

I am also pasting the full content of the PATH variable and LD_LIBRARY_PATH variable.

LD_LIBRARY_PATH=".:/applic/oracle/product/10.2.0/lib:/applic/informatica/910/ODBC6.1/lib:/usr/lib:./lib:/applic/informatica/910/java/lib:/applic/informatica/910/java/jre/lib:/applic/informatica/910/java/bin:/applic/informatica/910/server/bin:/lib64:/applic:/applic/Teradata15/teradata/client/15.10/tbuild/odbc/lib64"
PATH="/applic/oracle/product/10.2.0/bin:/applic/Teradata15/teradata/client/15.10/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/infa91adm/bin:/applic/informatica/910/ODBC6.1/bin:/applic/Teradata15/teradata/client/15.10/tbuild/:/applic/Teradata15/teradata/client/15.10/tbuild/bin:/applic/Teradata15/teradata/client/15.10/bin:/applic/Teradata15/teradata/client/15.10/lib:/applic/informatica/910/java/bin:/applic/informatica/910/java/jre/bin:/applic/informatica/910/server/bin"

 

Below is the TPT script -

/**********************************************************************************************
Parameterized TPT Script.
This tpt script is used as part of EDW ETL process to load source data into EDW Landing.
This script is for direct DB access to the source database where it is either Oracle or SQL Server platform.
All variables which are indicated between "<%" & "%>" will be replaced to appropriate values
by ETL shell script.

----------------------------------------------------------------------------------------------
Version | Author | Date |Change No | DESC
----------------------------------------------------------------------------------------------
0 | xxxxx **bleep** | 22/02/2013 | TBA | Script created
----------------------------------------------------------------------------------------------
**********************************************************************************************/

DEFINE JOB TPT_LOAD_POG_IX_SPC_PRODUCT
(
DEFINE OPERATOR LOAD_OPERATOR
TYPE UPDATE
SCHEMA *
ATTRIBUTES
(
VARCHAR UserName=@TPT_EDW_Connection_Update_Write_User
,VARCHAR UserPassword=@TPT_EDW_Connection_Update_Write_Password
,VARCHAR LogTable='TEST_EDW_WRK_DATA.POG_IX_SPC_PRODUCT_LOG'
,VARCHAR TargetTable='TEST_EDW_LDG_DATA.POG_IX_SPC_PRODUCT'
,INTEGER BufferSize
,INTEGER ErrorLimit
,INTEGER MaxSessions=8
,INTEGER MinSessions
,INTEGER TenacityHours=1
,INTEGER TenacitySleep=2
,VARCHAR AccountID
,VARCHAR DateForm
,VARCHAR ErrorTable='TEST_EDW_WRK_DATA.POG_IX_SPC_PRODUCT_ET'
,VARCHAR ErrorTable1='TEST_EDW_WRK_DATA.POG_IX_SPC_PRODUCT_ET1'
,VARCHAR ErrorTable2='TEST_EDW_WRK_DATA.POG_IX_SPC_PRODUCT_ET2'
,VARCHAR WorkTable='TEST_EDW_WRK_DATA.POG_IX_SPC_PRODUCT_WT'
,VARCHAR NotifyExit
,VARCHAR NotifyExitIsDLL
,VARCHAR NotifyLevel
,VARCHAR NotifyMethod
,VARCHAR NotifyString
,VARCHAR PauseAcq
,VARCHAR PrivateLogName
,VARCHAR TdpId=@TDTdpId
,VARCHAR TraceLevel
,VARCHAR WorkingDatabase='TEST_EDW_WRK_DATA'
,VARCHAR PackMaximum = 'YES'
);

DEFINE OPERATOR DDL_OPERATOR()
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DDL OPERATOR'
TYPE DDL
ATTRIBUTES
(
VARCHAR PrivateLogName = 'POG_IX_SPC_PRODUCT_ddl_log',
VARCHAR TdpId = @TDTdpId,
VARCHAR UserName = @td_USER_NAME,
VARCHAR UserPassword = @td_PASSWORD,
VARCHAR AccountID
);

DEFINE SCHEMA TABLE_SCHEMA
(
"DBTIME" VARCHAR(30), "DBUSER" VARCHAR(20), "DBPARENTPEGKEY" VARCHAR(30), "DBCURRENTUSER" VARCHAR(20), "DBSTATUS" VARCHAR(30), "DBKEY1" VARCHAR(30), "DBKEY2" VARCHAR(30), "DBKEY3" VARCHAR(30), "DBKEY4" VARCHAR(30), "DBKEY5" VARCHAR(30), "DBKEY6" VARCHAR(30), "DBKEY7" VARCHAR(30), "DBKEY8" VARCHAR(30), "DBKEY9" VARCHAR(30), "DBKEY10" VARCHAR(30), "UPC" VARCHAR(20), "SPC_PRODUCT_ID" VARCHAR(20), "SPC_PRODUCT_NAME" VARCHAR(100), "DBKEY" VARCHAR(30), "WIDTH" VARCHAR(50), "HEIGHT" VARCHAR(50), "DEPTH" VARCHAR(50), "COLOR" VARCHAR(30), "XNESTING" VARCHAR(50), "YNESTING" VARCHAR(50), "ZNESTING" VARCHAR(50), "PEGHOLES" VARCHAR(30), "PEGHOLEX" VARCHAR(50), "PEGHOLEY" VARCHAR(50), "PEGHOLEWIDTH" VARCHAR(50), "PEGHOLE2X" VARCHAR(50), "PEGHOLE2Y" VARCHAR(50), "PEGHOLE2WIDTH" VARCHAR(50), "PEGHOLE3X" VARCHAR(50), "PEGHOLE3Y" VARCHAR(50), "PEGHOLE3WIDTH" VARCHAR(50), "PACKAGESTYLE" VARCHAR(30), "PEGID" VARCHAR(100), "FINGERSPACEY" VARCHAR(50), "JUMBLEFACTOR" VARCHAR(50), "UNITMOVEMENT" VARCHAR(50), "SPC_PRODUCT_SHARE" VARCHAR(50), "CASEMULTIPLE" VARCHAR(50), "DAYSSUPPLY" VARCHAR(50), "COMBINEDPERFORMANCEINDEX" VARCHAR(50), "PEGSPAN" VARCHAR(30), "MINIMUMUNITS" VARCHAR(30), "MAXIMUMUNITS" VARCHAR(30), "SHAPEID" VARCHAR(30), "TRAYWIDTH" VARCHAR(50), "TRAYHEIGHT" VARCHAR(50), "TRAYDEPTH" VARCHAR(50), "TRAYNUMBERWIDE" VARCHAR(30), "TRAYNUMBERHIGH" VARCHAR(30), "TRAYNUMBERDEEP" VARCHAR(30), "TRAYTOTALNUMBER" VARCHAR(30), "TRAYMAXHIGH" VARCHAR(30), "CASEWIDTH" VARCHAR(50), "CASEHEIGHT" VARCHAR(50), "CASEDEPTH" VARCHAR(50), "CASENUMBERWIDE" VARCHAR(30), "CASENUMBERHIGH" VARCHAR(30), "CASENUMBERDEEP" VARCHAR(30), "CASETOTALNUMBER" VARCHAR(30), "CASEMAXHIGH" VARCHAR(30), "DISPLAYWIDTH" VARCHAR(50), "DISPLAYHEIGHT" VARCHAR(50), "DISPLAYDEPTH" VARCHAR(50), "DISPLAYNUMBERWIDE" VARCHAR(30), "DISPLAYNUMBERHIGH" VARCHAR(30), "DISPLAYNUMBERDEEP" VARCHAR(30), "DISPLAYTOTALNUMBER" VARCHAR(30), "DISPLAYMAXHIGH" VARCHAR(30), "ALTERNATEWIDTH" VARCHAR(50), "ALTERNATEHEIGHT" VARCHAR(50), "ALTERNATEDEPTH" VARCHAR(50), "ALTERNATENUMBERWIDE" VARCHAR(30), "ALTERNATENUMBERHIGH" VARCHAR(30), "ALTERNATENUMBERDEEP" VARCHAR(30), "ALTERNATETOTALNUMBER" VARCHAR(30), "ALTERNATEMAXHIGH" VARCHAR(30), "LOOSEWIDTH" VARCHAR(50), "LOOSEHEIGHT" VARCHAR(50), "LOOSEDEPTH" VARCHAR(50), "LOOSENUMBERWIDE" VARCHAR(30), "LOOSENUMBERHIGH" VARCHAR(30), "LOOSENUMBERDEEP" VARCHAR(30), "LOOSETOTALNUMBER" VARCHAR(30), "LOOSEMAXHIGH" VARCHAR(30), "MERCHXMIN" VARCHAR(30), "MERCHXMAX" VARCHAR(30), "MERCHXUPRIGHTS" VARCHAR(30), "MERCHXCAPS" VARCHAR(30), "MERCHXPLACEMENT" VARCHAR(30), "MERCHXNUMBER" VARCHAR(30), "MERCHXSIZE" VARCHAR(30), "MERCHXDIRECTION" VARCHAR(30), "MERCHYMIN" VARCHAR(30), "MERCHYMAX" VARCHAR(30), "MERCHYUPRIGHTS" VARCHAR(30), "MERCHYCAPS" VARCHAR(30), "MERCHYPLACEMENT" VARCHAR(30), "MERCHYNUMBER" VARCHAR(30), "MERCHYSIZE" VARCHAR(30), "MERCHYDIRECTION" VARCHAR(30), "MERCHZMIN" VARCHAR(30), "MERCHZMAX" VARCHAR(30), "MERCHZUPRIGHTS" VARCHAR(30), "MERCHZCAPS" VARCHAR(30), "MERCHZPLACEMENT" VARCHAR(30), "MERCHZNUMBER" VARCHAR(30), "MERCHZSIZE" VARCHAR(30), "MERCHZDIRECTION" VARCHAR(30), "NUMBEROFPOSITIONS" VARCHAR(30), "UNITCOST" VARCHAR(30), "DESC1" VARCHAR(1000), "DESC2" VARCHAR(1000), "DESC3" VARCHAR(1000), "DESC4" VARCHAR(1000), "DESC5" VARCHAR(1000), "DESC6" VARCHAR(1000), "DESC7" VARCHAR(1000), "DESC8" VARCHAR(1000), "DESC9" VARCHAR(1000), "DESC10" VARCHAR(1000), "DESC11" VARCHAR(1000), "DESC12" VARCHAR(1000), "DESC13" VARCHAR(1000), "DESC14" VARCHAR(1000), "DESC15" VARCHAR(1000), "DESC16" VARCHAR(1000), "DESC17" VARCHAR(1000), "DESC18" VARCHAR(1000), "DESC19" VARCHAR(1000), "DESC20" VARCHAR(1000), "DESC21" VARCHAR(1000), "DESC22" VARCHAR(1000), "DESC23" VARCHAR(1000), "DESC24" VARCHAR(1000), "DESC25" VARCHAR(1000), "DESC26" VARCHAR(1000), "DESC27" VARCHAR(1000), "DESC28" VARCHAR(1000), "DESC29" VARCHAR(1000), "DESC30" VARCHAR(1000), "DESC31" VARCHAR(1000), "DESC32" VARCHAR(1000), "DESC33" VARCHAR(1000), "DESC34" VARCHAR(1000), "DESC35" VARCHAR(1000), "DESC36" VARCHAR(1000), "DESC37" VARCHAR(1000), "DESC38" VARCHAR(1000), "DESC39" VARCHAR(1000), "DESC40" VARCHAR(1000), "DESC41" VARCHAR(1000), "DESC42" VARCHAR(1000), "DESC43" VARCHAR(1000), "DESC44" VARCHAR(1000), "DESC45" VARCHAR(1000), "DESC46" VARCHAR(1000), "DESC47" VARCHAR(1000), "DESC48" VARCHAR(1000), "DESC49" VARCHAR(1000), "DESC50" VARCHAR(1000), "VALUE1" VARCHAR(50), "VALUE2" VARCHAR(50), "VALUE3" VARCHAR(50), "VALUE4" VARCHAR(50), "VALUE5" VARCHAR(50), "VALUE6" VARCHAR(50), "VALUE7" VARCHAR(50), "VALUE8" VARCHAR(50), "VALUE9" VARCHAR(50), "VALUE10" VARCHAR(50), "VALUE11" VARCHAR(50), "VALUE12" VARCHAR(50), "VALUE13" VARCHAR(50), "VALUE14" VARCHAR(50), "VALUE15" VARCHAR(50), "VALUE16" VARCHAR(50), "VALUE17" VARCHAR(50), "VALUE18" VARCHAR(50), "VALUE19" VARCHAR(50), "VALUE20" VARCHAR(50), "VALUE21" VARCHAR(50), "VALUE22" VARCHAR(50), "VALUE23" VARCHAR(50), "VALUE24" VARCHAR(50), "VALUE25" VARCHAR(50), "VALUE26" VARCHAR(50), "VALUE27" VARCHAR(50), "VALUE28" VARCHAR(50), "VALUE29" VARCHAR(50), "VALUE30" VARCHAR(50), "VALUE31" VARCHAR(50), "VALUE32" VARCHAR(50), "VALUE33" VARCHAR(50), "VALUE34" VARCHAR(50), "VALUE35" VARCHAR(50), "VALUE36" VARCHAR(50), "VALUE37" VARCHAR(50), "VALUE38" VARCHAR(50), "VALUE39" VARCHAR(50), "VALUE40" VARCHAR(50), "VALUE41" VARCHAR(50), "VALUE42" VARCHAR(50), "VALUE43" VARCHAR(50), "VALUE44" VARCHAR(50), "VALUE45" VARCHAR(50), "VALUE46" VARCHAR(50), "VALUE47" VARCHAR(50), "VALUE48" VARCHAR(50), "VALUE49" VARCHAR(50), "VALUE50" VARCHAR(50), "FLAG1" VARCHAR(50), "FLAG2" VARCHAR(50), "FLAG3" VARCHAR(50), "FLAG4" VARCHAR(50), "FLAG5" VARCHAR(50), "FLAG6" VARCHAR(50), "FLAG7" VARCHAR(50), "FLAG8" VARCHAR(50), "FLAG9" VARCHAR(50), "FLAG10" VARCHAR(50), "MINIMUMSQUEEZEFACTORX" VARCHAR(50), "MINIMUMSQUEEZEFACTORY" VARCHAR(50), "MINIMUMSQUEEZEFACTORZ" VARCHAR(50), "MAXIMUMSQUEEZEFACTORX" VARCHAR(50), "MAXIMUMSQUEEZEFACTORY" VARCHAR(50), "MAXIMUMSQUEEZEFACTORZ" VARCHAR(50), "BRAND" VARCHAR(1000), "SUBCATEGORY" VARCHAR(1000), "WEIGHT" VARCHAR(50), "PLANOGRAMALIAS" VARCHAR(1000), "FRONTOVERHANG" VARCHAR(50), "FINGERSPACEX" VARCHAR(50), "STATUS" VARCHAR(50), "DATECREATED" VARCHAR(20), "DATEMODIFIED" VARCHAR(20), "DATEPENDING" VARCHAR(20), "DATEEFFECTIVE" VARCHAR(20), "DATEFINISHED" VARCHAR(20), "DATE1" VARCHAR(20), "DATE2" VARCHAR(20), "DATE3" VARCHAR(20), "CREATEDBY" VARCHAR(100), "MODIFIEDBY" VARCHAR(100), "PEAKSAFETYFACTOR" VARCHAR(50), "BACKROOMSTOCK" VARCHAR(50), "DELIVERYSCHEDULE" VARCHAR(50), "DBDATEEFFECTIVEFROM" VARCHAR(20), "DBDATEEFFECTIVETO" VARCHAR(20), "DBVERSIONKEY" VARCHAR(50), "PARTID" VARCHAR(50), "CAPACITYUNRESTRICTED" VARCHAR(50), "DEFAULTMERCHSTYLE" VARCHAR(50), "AUTOMATICMODEL" VARCHAR(50), "DBGUID" VARCHAR(36), "SPC_PRODUCT_SOURCE" VARCHAR(50), "TECHNICALKEY" VARCHAR(50), "SQUEEZEEXPANDUNITSONLY" VARCHAR(50), "ASSORTMENTNOTE" VARCHAR(1000), "METAPRODUCT" VARCHAR(50)
);

DEFINE OPERATOR READ_OPERATOR
TYPE ODBC
SCHEMA TABLE_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName,
VARCHAR ConnectString,
VARCHAR TruncateData = 'Yes',
VARCHAR DSNName = @POG_IX_DSN,
VARCHAR UserName = @POG_IX_UserName,
VARCHAR UserPassword = @POG_IX_Password,
VARCHAR SelectStmt = 'SELECT TO_CHAR(DBTIME), TO_CHAR(DBUSER), TO_CHAR(DBPARENTPEGKEY), TO_CHAR(DBCURRENTUSER), TO_CHAR(DBSTATUS), TO_CHAR(DBKEY1), TO_CHAR(DBKEY2), TO_CHAR(DBKEY3), TO_CHAR(DBKEY4), TO_CHAR(DBKEY5), TO_CHAR(DBKEY6), TO_CHAR(DBKEY7), TO_CHAR(DBKEY8), TO_CHAR(DBKEY9), TO_CHAR(DBKEY10), TO_CHAR(UPC), TO_CHAR(SPC_PRODUCT_ID), TO_CHAR(SPC_PRODUCT_NAME), TO_CHAR(DBKEY), TO_CHAR(WIDTH), TO_CHAR(HEIGHT), TO_CHAR(DEPTH), TO_CHAR(COLOR), TO_CHAR(XNESTING), TO_CHAR(YNESTING), TO_CHAR(ZNESTING), TO_CHAR(PEGHOLES), TO_CHAR(PEGHOLEX), TO_CHAR(PEGHOLEY), TO_CHAR(PEGHOLEWIDTH), TO_CHAR(PEGHOLE2X), TO_CHAR(PEGHOLE2Y), TO_CHAR(PEGHOLE2WIDTH), TO_CHAR(PEGHOLE3X), TO_CHAR(PEGHOLE3Y), TO_CHAR(PEGHOLE3WIDTH), TO_CHAR(PACKAGESTYLE), TO_CHAR(PEGID), TO_CHAR(FINGERSPACEY), TO_CHAR(JUMBLEFACTOR), TO_CHAR(UNITMOVEMENT), TO_CHAR(SPC_PRODUCT_SHARE), TO_CHAR(CASEMULTIPLE), TO_CHAR(DAYSSUPPLY), TO_CHAR(COMBINEDPERFORMANCEINDEX), TO_CHAR(PEGSPAN), TO_CHAR(MINIMUMUNITS), TO_CHAR(MAXIMUMUNITS), TO_CHAR(SHAPEID), TO_CHAR(TRAYWIDTH), TO_CHAR(TRAYHEIGHT), TO_CHAR(TRAYDEPTH), TO_CHAR(TRAYNUMBERWIDE), TO_CHAR(TRAYNUMBERHIGH), TO_CHAR(TRAYNUMBERDEEP), TO_CHAR(TRAYTOTALNUMBER), TO_CHAR(TRAYMAXHIGH), TO_CHAR(CASEWIDTH), TO_CHAR(CASEHEIGHT), TO_CHAR(CASEDEPTH), TO_CHAR(CASENUMBERWIDE), TO_CHAR(CASENUMBERHIGH), TO_CHAR(CASENUMBERDEEP), TO_CHAR(CASETOTALNUMBER), TO_CHAR(CASEMAXHIGH), TO_CHAR(DISPLAYWIDTH), TO_CHAR(DISPLAYHEIGHT), TO_CHAR(DISPLAYDEPTH), TO_CHAR(DISPLAYNUMBERWIDE), TO_CHAR(DISPLAYNUMBERHIGH), TO_CHAR(DISPLAYNUMBERDEEP), TO_CHAR(DISPLAYTOTALNUMBER), TO_CHAR(DISPLAYMAXHIGH), TO_CHAR(ALTERNATEWIDTH), TO_CHAR(ALTERNATEHEIGHT), TO_CHAR(ALTERNATEDEPTH), TO_CHAR(ALTERNATENUMBERWIDE), TO_CHAR(ALTERNATENUMBERHIGH), TO_CHAR(ALTERNATENUMBERDEEP), TO_CHAR(ALTERNATETOTALNUMBER), TO_CHAR(ALTERNATEMAXHIGH), TO_CHAR(LOOSEWIDTH), TO_CHAR(LOOSEHEIGHT), TO_CHAR(LOOSEDEPTH), TO_CHAR(LOOSENUMBERWIDE), TO_CHAR(LOOSENUMBERHIGH), TO_CHAR(LOOSENUMBERDEEP), TO_CHAR(LOOSETOTALNUMBER), TO_CHAR(LOOSEMAXHIGH), TO_CHAR(MERCHXMIN), TO_CHAR(MERCHXMAX), TO_CHAR(MERCHXUPRIGHTS), TO_CHAR(MERCHXCAPS), TO_CHAR(MERCHXPLACEMENT), TO_CHAR(MERCHXNUMBER), TO_CHAR(MERCHXSIZE), TO_CHAR(MERCHXDIRECTION), TO_CHAR(MERCHYMIN), TO_CHAR(MERCHYMAX), TO_CHAR(MERCHYUPRIGHTS), TO_CHAR(MERCHYCAPS), TO_CHAR(MERCHYPLACEMENT), TO_CHAR(MERCHYNUMBER), TO_CHAR(MERCHYSIZE), TO_CHAR(MERCHYDIRECTION), TO_CHAR(MERCHZMIN), TO_CHAR(MERCHZMAX), TO_CHAR(MERCHZUPRIGHTS), TO_CHAR(MERCHZCAPS), TO_CHAR(MERCHZPLACEMENT), TO_CHAR(MERCHZNUMBER), TO_CHAR(MERCHZSIZE), TO_CHAR(MERCHZDIRECTION), TO_CHAR(NUMBEROFPOSITIONS), TO_CHAR(UNITCOST), DESC1, DESC2, DESC3, DESC4, DESC5, DESC6, DESC7, DESC8, DESC9, DESC10, DESC11, DESC12, DESC13, DESC14, DESC15, DESC16, DESC17, DESC18, DESC19, DESC20, DESC21, DESC22, DESC23, DESC24, DESC25, DESC26, DESC27, DESC28, DESC29, DESC30, DESC31, DESC32, DESC33, DESC34, DESC35, DESC36, DESC37, DESC38, DESC39, DESC40, DESC41, DESC42, DESC43, DESC44, DESC45, DESC46, DESC47, DESC48, DESC49, DESC50, TO_CHAR(VALUE1), TO_CHAR(VALUE2), TO_CHAR(VALUE3), TO_CHAR(VALUE4), TO_CHAR(VALUE5), TO_CHAR(VALUE6), TO_CHAR(VALUE7), TO_CHAR(VALUE8), TO_CHAR(VALUE9), TO_CHAR(VALUE10), TO_CHAR(VALUE11), TO_CHAR(VALUE12), TO_CHAR(VALUE13), TO_CHAR(VALUE14), TO_CHAR(VALUE15), TO_CHAR(VALUE16), TO_CHAR(VALUE17), TO_CHAR(VALUE18), TO_CHAR(VALUE19), TO_CHAR(VALUE20), TO_CHAR(VALUE21), TO_CHAR(VALUE22), TO_CHAR(VALUE23), TO_CHAR(VALUE24), TO_CHAR(VALUE25), TO_CHAR(VALUE26), TO_CHAR(VALUE27), TO_CHAR(VALUE28), TO_CHAR(VALUE29), TO_CHAR(VALUE30), TO_CHAR(VALUE31), TO_CHAR(VALUE32), TO_CHAR(VALUE33), TO_CHAR(VALUE34), TO_CHAR(VALUE35), TO_CHAR(VALUE36), TO_CHAR(VALUE37), TO_CHAR(VALUE38), TO_CHAR(VALUE39), TO_CHAR(VALUE40), TO_CHAR(VALUE41), TO_CHAR(VALUE42), TO_CHAR(VALUE43), TO_CHAR(VALUE44), TO_CHAR(VALUE45), TO_CHAR(VALUE46), TO_CHAR(VALUE47), TO_CHAR(VALUE48), TO_CHAR(VALUE49), TO_CHAR(VALUE50), TO_CHAR(FLAG1), TO_CHAR(FLAG2), TO_CHAR(FLAG3), TO_CHAR(FLAG4), TO_CHAR(FLAG5), TO_CHAR(FLAG6), TO_CHAR(FLAG7), TO_CHAR(FLAG8), TO_CHAR(FLAG9), TO_CHAR(FLAG10), TO_CHAR(MINIMUMSQUEEZEFACTORX), TO_CHAR(MINIMUMSQUEEZEFACTORY), TO_CHAR(MINIMUMSQUEEZEFACTORZ), TO_CHAR(MAXIMUMSQUEEZEFACTORX), TO_CHAR(MAXIMUMSQUEEZEFACTORY), TO_CHAR(MAXIMUMSQUEEZEFACTORZ), BRAND, SUBCATEGORY, TO_CHAR(WEIGHT), PLANOGRAMALIAS, TO_CHAR(FRONTOVERHANG), TO_CHAR(FINGERSPACEX), TO_CHAR(STATUS), TO_CHAR(DATECREATED), TO_CHAR(DATEMODIFIED), TO_CHAR(DATEPENDING), TO_CHAR(DATEEFFECTIVE), TO_CHAR(DATEFINISHED), TO_CHAR(DATE1), TO_CHAR(DATE2), TO_CHAR(DATE3), TO_CHAR(CREATEDBY), TO_CHAR(MODIFIEDBY), TO_CHAR(PEAKSAFETYFACTOR), TO_CHAR(BACKROOMSTOCK), TO_CHAR(DELIVERYSCHEDULE), TO_CHAR(DBDATEEFFECTIVEFROM), TO_CHAR(DBDATEEFFECTIVETO), TO_CHAR(DBVERSIONKEY), TO_CHAR(PARTID), TO_CHAR(CAPACITYUNRESTRICTED), TO_CHAR(DEFAULTMERCHSTYLE), TO_CHAR(AUTOMATICMODEL), TO_CHAR(DBGUID), TO_CHAR(SPC_PRODUCT_SOURCE), TO_CHAR(TECHNICALKEY), TO_CHAR(SQUEEZEEXPANDUNITSONLY), ASSORTMENTNOTE, TO_CHAR(METAPRODUCT) FROM TCR_APPLIC.V_IX_SPC_PRODUCT ;'
);

STEP pre_load
(
APPLY
('DELETE FROM TEST_EDW_LDG_DATA.POG_IX_SPC_PRODUCT ALL;')
TO OPERATOR (DDL_OPERATOR () );
);

Step load_the_data
(
APPLY
(
'INSERT INTO TEST_EDW_LDG_DATA.POG_IX_SPC_PRODUCT (
DBTIME, DBUSER, DBPARENTPEGKEY, DBCURRENTUSER, DBSTATUS, DBKEY1, DBKEY2, DBKEY3, DBKEY4, DBKEY5, DBKEY6, DBKEY7, DBKEY8, DBKEY9, DBKEY10, UPC, SPC_PRODUCT_ID, SPC_PRODUCT_NAME, DBKEY, WIDTH, HEIGHT, DEPTH, COLOR, XNESTING, YNESTING, ZNESTING, PEGHOLES, PEGHOLEX, PEGHOLEY, PEGHOLEWIDTH, PEGHOLE2X, PEGHOLE2Y, PEGHOLE2WIDTH, PEGHOLE3X, PEGHOLE3Y, PEGHOLE3WIDTH, PACKAGESTYLE, PEGID, FINGERSPACEY, JUMBLEFACTOR, UNITMOVEMENT, SPC_PRODUCT_SHARE, CASEMULTIPLE, DAYSSUPPLY, COMBINEDPERFORMANCEINDEX, PEGSPAN, MINIMUMUNITS, MAXIMUMUNITS, SHAPEID, TRAYWIDTH, TRAYHEIGHT, TRAYDEPTH, TRAYNUMBERWIDE, TRAYNUMBERHIGH, TRAYNUMBERDEEP, TRAYTOTALNUMBER, TRAYMAXHIGH, CASEWIDTH, CASEHEIGHT, CASEDEPTH, CASENUMBERWIDE, CASENUMBERHIGH, CASENUMBERDEEP, CASETOTALNUMBER, CASEMAXHIGH, DISPLAYWIDTH, DISPLAYHEIGHT, DISPLAYDEPTH, DISPLAYNUMBERWIDE, DISPLAYNUMBERHIGH, DISPLAYNUMBERDEEP, DISPLAYTOTALNUMBER, DISPLAYMAXHIGH, ALTERNATEWIDTH, ALTERNATEHEIGHT, ALTERNATEDEPTH, ALTERNATENUMBERWIDE, ALTERNATENUMBERHIGH, ALTERNATENUMBERDEEP, ALTERNATETOTALNUMBER, ALTERNATEMAXHIGH, LOOSEWIDTH, LOOSEHEIGHT, LOOSEDEPTH, LOOSENUMBERWIDE, LOOSENUMBERHIGH, LOOSENUMBERDEEP, LOOSETOTALNUMBER, LOOSEMAXHIGH, MERCHXMIN, MERCHXMAX, MERCHXUPRIGHTS, MERCHXCAPS, MERCHXPLACEMENT, MERCHXNUMBER, MERCHXSIZE, MERCHXDIRECTION, MERCHYMIN, MERCHYMAX, MERCHYUPRIGHTS, MERCHYCAPS, MERCHYPLACEMENT, MERCHYNUMBER, MERCHYSIZE, MERCHYDIRECTION, MERCHZMIN, MERCHZMAX, MERCHZUPRIGHTS, MERCHZCAPS, MERCHZPLACEMENT, MERCHZNUMBER, MERCHZSIZE, MERCHZDIRECTION, NUMBEROFPOSITIONS, UNITCOST, DESC1, DESC2, DESC3, DESC4, DESC5, DESC6, DESC7, DESC8, DESC9, DESC10, DESC11, DESC12, DESC13, DESC14, DESC15, DESC16, DESC17, DESC18, DESC19, DESC20, DESC21, DESC22, DESC23, DESC24, DESC25, DESC26, DESC27, DESC28, DESC29, DESC30, DESC31, DESC32, DESC33, DESC34, DESC35, DESC36, DESC37, DESC38, DESC39, DESC40, DESC41, DESC42, DESC43, DESC44, DESC45, DESC46, DESC47, DESC48, DESC49, DESC50, VALUE1, VALUE2, VALUE3, VALUE4, VALUE5, VALUE6, VALUE7, VALUE8, VALUE9, VALUE10, VALUE11, VALUE12, VALUE13, VALUE14, VALUE15, VALUE16, VALUE17, VALUE18, VALUE19, VALUE20, VALUE21, VALUE22, VALUE23, VALUE24, VALUE25, VALUE26, VALUE27, VALUE28, VALUE29, VALUE30, VALUE31, VALUE32, VALUE33, VALUE34, VALUE35, VALUE36, VALUE37, VALUE38, VALUE39, VALUE40, VALUE41, VALUE42, VALUE43, VALUE44, VALUE45, VALUE46, VALUE47, VALUE48, VALUE49, VALUE50, FLAG1, FLAG2, FLAG3, FLAG4, FLAG5, FLAG6, FLAG7, FLAG8, FLAG9, FLAG10, MINIMUMSQUEEZEFACTORX, MINIMUMSQUEEZEFACTORY, MINIMUMSQUEEZEFACTORZ, MAXIMUMSQUEEZEFACTORX, MAXIMUMSQUEEZEFACTORY, MAXIMUMSQUEEZEFACTORZ, BRAND, SUBCATEGORY, WEIGHT, PLANOGRAMALIAS, FRONTOVERHANG, FINGERSPACEX, STATUS, DATECREATED, DATEMODIFIED, DATEPENDING, DATEEFFECTIVE, DATEFINISHED, DATE1, DATE2, DATE3, CREATEDBY, MODIFIEDBY, PEAKSAFETYFACTOR, BACKROOMSTOCK, DELIVERYSCHEDULE, DBDATEEFFECTIVEFROM, DBDATEEFFECTIVETO, DBVERSIONKEY, PARTID, CAPACITYUNRESTRICTED, DEFAULTMERCHSTYLE, AUTOMATICMODEL, DBGUID, SPC_PRODUCT_SOURCE, TECHNICALKEY, SQUEEZEEXPANDUNITSONLY, ASSORTMENTNOTE, METAPRODUCT, SS_EFF_TMSTMP, DW_LOAD_TMSTMP
)
VALUES (
:DBTIME, :DBUSER, :DBPARENTPEGKEY, :DBCURRENTUSER, :DBSTATUS, :DBKEY1, :DBKEY2, :DBKEY3, :DBKEY4, :DBKEY5, :DBKEY6, :DBKEY7, :DBKEY8, :DBKEY9, :DBKEY10, :UPC, :SPC_PRODUCT_ID, :SPC_PRODUCT_NAME, :DBKEY, :WIDTH, :HEIGHT, :DEPTH, :COLOR, :XNESTING, :YNESTING, :ZNESTING, :PEGHOLES, :PEGHOLEX, :PEGHOLEY, :PEGHOLEWIDTH, :PEGHOLE2X, :PEGHOLE2Y, :PEGHOLE2WIDTH, :PEGHOLE3X, :PEGHOLE3Y, :PEGHOLE3WIDTH, :PACKAGESTYLE, :PEGID, :FINGERSPACEY, :JUMBLEFACTOR, :UNITMOVEMENT, :SPC_PRODUCT_SHARE, :CASEMULTIPLE, :DAYSSUPPLY, :COMBINEDPERFORMANCEINDEX, :PEGSPAN, :MINIMUMUNITS, :MAXIMUMUNITS, :SHAPEID, :TRAYWIDTH, :TRAYHEIGHT, :TRAYDEPTH, :TRAYNUMBERWIDE, :TRAYNUMBERHIGH, :TRAYNUMBERDEEP, :TRAYTOTALNUMBER, :TRAYMAXHIGH, :CASEWIDTH, :CASEHEIGHT, :CASEDEPTH, :CASENUMBERWIDE, :CASENUMBERHIGH, :CASENUMBERDEEP, :CASETOTALNUMBER, :CASEMAXHIGH, :DISPLAYWIDTH, :DISPLAYHEIGHT, :DISPLAYDEPTH, :DISPLAYNUMBERWIDE, :DISPLAYNUMBERHIGH, :DISPLAYNUMBERDEEP, :DISPLAYTOTALNUMBER, :DISPLAYMAXHIGH, :ALTERNATEWIDTH, :ALTERNATEHEIGHT, :ALTERNATEDEPTH, :ALTERNATENUMBERWIDE, :ALTERNATENUMBERHIGH, :ALTERNATENUMBERDEEP, :ALTERNATETOTALNUMBER, :ALTERNATEMAXHIGH, :LOOSEWIDTH, :LOOSEHEIGHT, :LOOSEDEPTH, :LOOSENUMBERWIDE, :LOOSENUMBERHIGH, :LOOSENUMBERDEEP, :LOOSETOTALNUMBER, :LOOSEMAXHIGH, :MERCHXMIN, :MERCHXMAX, :MERCHXUPRIGHTS, :MERCHXCAPS, :MERCHXPLACEMENT, :MERCHXNUMBER, :MERCHXSIZE, :MERCHXDIRECTION, :MERCHYMIN, :MERCHYMAX, :MERCHYUPRIGHTS, :MERCHYCAPS, :MERCHYPLACEMENT, :MERCHYNUMBER, :MERCHYSIZE, :MERCHYDIRECTION, :MERCHZMIN, :MERCHZMAX, :MERCHZUPRIGHTS, :MERCHZCAPS, :MERCHZPLACEMENT, :MERCHZNUMBER, :MERCHZSIZE, :MERCHZDIRECTION, :NUMBEROFPOSITIONS, :UNITCOST, :DESC1, :DESC2, :DESC3, :DESC4, :DESC5, :DESC6, :DESC7, :DESC8, :DESC9, :DESC10, :DESC11, :DESC12, :DESC13, :DESC14, :DESC15, :DESC16, :DESC17, :DESC18, :DESC19, :DESC20, :DESC21, :DESC22, :DESC23, :DESC24, :DESC25, :DESC26, :DESC27, :DESC28, :DESC29, :DESC30, :DESC31, :DESC32, :DESC33, :DESC34, :DESC35, :DESC36, :DESC37, :DESC38, :DESC39, :DESC40, :DESC41, :DESC42, :DESC43, :DESC44, :DESC45, :DESC46, :DESC47, :DESC48, :DESC49, :DESC50, :VALUE1, :VALUE2, :VALUE3, :VALUE4, :VALUE5, :VALUE6, :VALUE7, :VALUE8, :VALUE9, :VALUE10, :VALUE11, :VALUE12, :VALUE13, :VALUE14, :VALUE15, :VALUE16, :VALUE17, :VALUE18, :VALUE19, :VALUE20, :VALUE21, :VALUE22, :VALUE23, :VALUE24, :VALUE25, :VALUE26, :VALUE27, :VALUE28, :VALUE29, :VALUE30, :VALUE31, :VALUE32, :VALUE33, :VALUE34, :VALUE35, :VALUE36, :VALUE37, :VALUE38, :VALUE39, :VALUE40, :VALUE41, :VALUE42, :VALUE43, :VALUE44, :VALUE45, :VALUE46, :VALUE47, :VALUE48, :VALUE49, :VALUE50, :FLAG1, :FLAG2, :FLAG3, :FLAG4, :FLAG5, :FLAG6, :FLAG7, :FLAG8, :FLAG9, :FLAG10, :MINIMUMSQUEEZEFACTORX, :MINIMUMSQUEEZEFACTORY, :MINIMUMSQUEEZEFACTORZ, :MAXIMUMSQUEEZEFACTORX, :MAXIMUMSQUEEZEFACTORY, :MAXIMUMSQUEEZEFACTORZ, :BRAND, :SUBCATEGORY, :WEIGHT, :PLANOGRAMALIAS, :FRONTOVERHANG, :FINGERSPACEX, :STATUS, :DATECREATED, :DATEMODIFIED, :DATEPENDING, :DATEEFFECTIVE, :DATEFINISHED, :DATE1, :DATE2, :DATE3, :CREATEDBY, :MODIFIEDBY, :PEAKSAFETYFACTOR, :BACKROOMSTOCK, :DELIVERYSCHEDULE, :DBDATEEFFECTIVEFROM, :DBDATEEFFECTIVETO, :DBVERSIONKEY, :PARTID, :CAPACITYUNRESTRICTED, :DEFAULTMERCHSTYLE, :AUTOMATICMODEL, :DBGUID, :SPC_PRODUCT_SOURCE, :TECHNICALKEY, :SQUEEZEEXPANDUNITSONLY, :ASSORTMENTNOTE, :METAPRODUCT
,TIMESTAMP''2018-04-18 12:45:17''
,TIMESTAMP''2016-11-25 23:59:59''
);'
) SERIALIZE ON ("SPC_PRODUCT_ID")
TO OPERATOR ( LOAD_OPERATOR () )
SELECT * FROM OPERATOR ( READ_OPERATOR () );
);

STEP post_load
(
APPLY
('COLLECT STATISTICS ON TEST_EDW_LDG_DATA.POG_IX_SPC_PRODUCT COLUMN (SPC_PRODUCT_ID);')
TO OPERATOR (DDL_OPERATOR () );
);
);

 

Below is the error message.

Teradata Parallel Transporter Version 15.10.01.06 64-Bit
Job log: /applic/Teradata15/teradata/client/15.10/tbuild/logs/DB_LDG_POG_IX_SPC_PRODUCT-421.out
Job id is DB_LDG_POG_IX_SPC_PRODUCT-421, running on cletlt2
Found CheckPoint file: /applic/Teradata15/teradata/client/15.10/tbuild/checkpoint/DB_LDG_POG_IX_SPC_PRODUCTLVCP
This is a restart job; it restarts at step load_the_data.
Teradata Parallel Transporter ODBC Operator Version 15.10.01.06
READ_OPERATOR: private log not specified
Teradata Parallel Transporter Update Operator Version 15.10.01.06
LOAD_OPERATOR: private log not specified
LOAD_OPERATOR: connecting sessions
READ_OPERATOR: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file: No such file or directory'
LOAD_OPERATOR: preparing target table(s)
LOAD_OPERATOR: entering DML Phase
LOAD_OPERATOR: entering Acquisition Phase
READ_OPERATOR: Total processor time used = '0.004999 Second(s)'
READ_OPERATOR: Start : Tue Apr 17 14:34:21 2018
READ_OPERATOR: End : Tue Apr 17 14:34:24 2018
LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.508922 Second(s)'
LOAD_OPERATOR: Start : Tue Apr 17 14:34:21 2018
LOAD_OPERATOR: End : Tue Apr 17 14:34:25 2018
Job step load_the_data terminated (status 12)
Job DB_LDG_POG_IX_SPC_PRODUCT terminated (status 12)
Job start: Tue Apr 17 14:34:16 2018
Job end: Tue Apr 17 14:34:25 2018

 

I should also tell that the TPT version was upgraded recently post which we started seeing this error message. The previous version was 13.10.00.14.

 

Any help is appreicated.

 

Many Thanks,
Abhinav Mishra

2 REPLIES
Teradata Employee

Re: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file or directory

With the more recent TTU releases, TD utilities rely on relative paths to find shared libraries, rather than environment variables. Did the base install for the new TTU version use the .setup.sh script as outlined in the Installation Guide? If you install packages separately, all the components should specify the same "installation path" so the relative structure will be correct.

Teradata Employee

Re: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file or directory

The error you are getting is not from TPT specifically, but from the ODBC driver manager.

Unfortunately, DataDirect has changed the way the driver manager works, and it now requires LD_LIBRARY_PATH to be set.

(We are not happy about that because with our new way of using relative paths to find our own internal libraries, we were able to avoid the reliance on these environment variables.)

-- SteveF