Run-time error '6'

sumitgulati · Post by **sumitgulati** » Thu Aug 05, 2004 5:49 pm

Hi All,

When I try importing a table from DataStage Manager using Import\TableDefinition\ODBCTableDefinition I get the following error message for certain set of tables:

"Run-time error '6':
Overflow"

Though the import works perfectly fine with some tables. I am not able to figure out why for some tables it throws the above mentioned error message.

Does anyone have any idea why could this be?

Thanks in advance,
Sumit

rasi · Post by **rasi** » Fri Aug 06, 2004 12:38 am

Is this error specific to your pc. Try doing the same in another machine.

Rasi

mhester · Post by **mhester** » Fri Aug 06, 2004 6:41 am

These types of errors generally occur when a variable is assigned a value that is too large - i.e., long data to an int or an assignment to a property that exceeds the maximum value the property can accept.

The above is from the MSDN.

This used to happen in earlier versions of DataStage, but I had not heard of it in a while. If you think about what is happening then maybe you can identify something within this particular set of tables that might be causing the problem like number of columns, name of the column etc... - maybe the name of a column is too large - who knows. Could be anything.

If not and this issue continues then it seems to me that simply contacting support and sending them the ddl for these tables and allowing them to experience this problem would be in your best interest and likely would result in an answer or solution.

Regards,

sumitgulati · Post by **sumitgulati** » Fri Aug 06, 2004 11:13 am

Thanks for the suggestion guys but the error seems to be something else.

No the error is not system specific. I tried it from two different systems. Its gives the same error in both.

I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.

Here is the ddl for the table I am trying to import:

Name Null? Type
----------------------------------------- -------- ----------------------------
BUSINESS_UNIT NOT NULL VARCHAR2(5)
VCHR_BLD_KEY_C1 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_C2 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_N1 NOT NULL NUMBER(10)
VCHR_BLD_KEY_N2 NOT NULL NUMBER(10)
VOUCHER_ID NOT NULL VARCHAR2(8)
VOUCHER_STYLE NOT NULL VARCHAR2(4)
INVOICE_ID NOT NULL VARCHAR2(30)
INVOICE_DT NOT NULL DATE
VENDOR_SETID NOT NULL VARCHAR2(5)
VENDOR_ID NOT NULL VARCHAR2(10)
VNDR_LOC NOT NULL VARCHAR2(10)
ADDRESS_SEQ_NUM NOT NULL NUMBER(38)
GRP_AP_ID NOT NULL VARCHAR2(10)
ORIGIN NOT NULL VARCHAR2(3)
OPRID NOT NULL VARCHAR2(30)
ACCOUNTING_DT DATE
POST_VOUCHER NOT NULL VARCHAR2(1)
DST_CNTRL_ID NOT NULL VARCHAR2(10)
VOUCHER_ID_RELATED NOT NULL VARCHAR2(8)
GROSS_AMT NOT NULL NUMBER(26,3)
DSCNT_AMT NOT NULL NUMBER(26,3)
TAX_EXEMPT NOT NULL VARCHAR2(1)
SALETX_AMT NOT NULL NUMBER(26,3)
FREIGHT_AMT NOT NULL NUMBER(26,3)
MISC_AMT NOT NULL NUMBER(26,3)
PYMNT_TERMS_CD NOT NULL VARCHAR2(5)
ENTERED_DT DATE
TXN_CURRENCY_CD NOT NULL VARCHAR2(3)
RT_TYPE NOT NULL VARCHAR2(5)
RATE_MULT NOT NULL NUMBER(15,8)
RATE_DIV NOT NULL NUMBER(15,8)
VAT_ENTRD_AMT NOT NULL NUMBER(26,3)
MATCH_ACTION NOT NULL VARCHAR2(1)
CUR_RT_SOURCE NOT NULL VARCHAR2(1)
DSCNT_AMT_FLG NOT NULL VARCHAR2(1)
DUE_DT_FLG NOT NULL VARCHAR2(1)
VCHR_APPRVL_FLG NOT NULL VARCHAR2(1)
BUSPROCNAME NOT NULL VARCHAR2(30)
APPR_RULE_SET NOT NULL VARCHAR2(30)
VAT_DCLRTN_POINT NOT NULL VARCHAR2(1)
VAT_CALC_TYPE NOT NULL VARCHAR2(1)
VAT_CALC_GROSS_NET NOT NULL VARCHAR2(1)
VAT_RECALC_FLG NOT NULL VARCHAR2(1)
VAT_CALC_FRGHT_FLG NOT NULL VARCHAR2(1)
VAT_TREATMENT_GRP NOT NULL VARCHAR2(4)
COUNTRY_SHIP_FROM NOT NULL VARCHAR2(3)
STATE_SHIP_FROM NOT NULL VARCHAR2(6)
COUNTRY_SHIP_TO NOT NULL VARCHAR2(3)
STATE_SHIP_TO NOT NULL VARCHAR2(6)
COUNTRY_VAT_BILLFR NOT NULL VARCHAR2(3)
COUNTRY_VAT_BILLTO NOT NULL VARCHAR2(3)
VAT_EXCPTN_CERTIF NOT NULL VARCHAR2(20)
VAT_ROUND_RULE NOT NULL VARCHAR2(1)
COUNTRY_LOC_SELLER NOT NULL VARCHAR2(3)
STATE_LOC_SELLER NOT NULL VARCHAR2(6)
COUNTRY_LOC_BUYER NOT NULL VARCHAR2(3)
STATE_LOC_BUYER NOT NULL VARCHAR2(6)
COUNTRY_VAT_SUPPLY NOT NULL VARCHAR2(3)
STATE_VAT_SUPPLY NOT NULL VARCHAR2(6)
COUNTRY_VAT_PERFRM NOT NULL VARCHAR2(3)
STATE_VAT_PERFRM NOT NULL VARCHAR2(6)
STATE_VAT_DEFAULT NOT NULL VARCHAR2(6)
PREPAID_REF NOT NULL VARCHAR2(10)
PREPAID_AUTO_APPLY NOT NULL VARCHAR2(1)
DESCR254_MIXED NOT NULL VARCHAR2(254)
EIN_FEDERAL NOT NULL VARCHAR2(9)
EIN_STATE_LOCAL NOT NULL VARCHAR2(20)
PROCESS_INSTANCE NOT NULL NUMBER(10)
IN_PROCESS_FLG NOT NULL VARCHAR2(1)
BUSINESS_UNIT_PO NOT NULL VARCHAR2(5)
PO_ID NOT NULL VARCHAR2(10)
PACKSLIP_NO NOT NULL VARCHAR2(22)
PAY_TRM_BSE_DT_OPT NOT NULL VARCHAR2(1)
VAT_CALC_MISC_FLG NOT NULL VARCHAR2(1)
IMAGE_REF_ID NOT NULL VARCHAR2(12)
IMAGE_DATE DATE
PAY_SCHEDULE_TYPE NOT NULL VARCHAR2(3)
TAX_GRP NOT NULL VARCHAR2(4)
TAX_PYMNT_TYPE NOT NULL VARCHAR2(5)
INSPECT_DT DATE
INV_RECPT_DT DATE
RECEIPT_DT DATE
BILL_OF_LADING NOT NULL VARCHAR2(30)
CARRIER_ID NOT NULL VARCHAR2(10)
DOC_TYPE NOT NULL VARCHAR2(8)
DSCNT_DUE_DT DATE
DSCNT_PRORATE_FLG NOT NULL VARCHAR2(1)
DUE_DT DATE
ECQUEUEINSTANCE NOT NULL NUMBER(38)
ECTRANSID NOT NULL VARCHAR2(15)
FRGHT_CHARGE_CODE NOT NULL VARCHAR2(10)
LC_ID NOT NULL VARCHAR2(12)
MISC_CHARGE_CODE NOT NULL VARCHAR2(10)
REMIT_ADDR_SEQ_NUM NOT NULL NUMBER(38)
SALETX_CHARGE_CODE NOT NULL VARCHAR2(10)
VCHR_BLD_CODE NOT NULL VARCHAR2(6)
BUSINESS_UNIT_AR NOT NULL VARCHAR2(5)
CUST_ID NOT NULL VARCHAR2(15)
ITEM NOT NULL VARCHAR2(30)
ITEM_LINE NOT NULL NUMBER(38)
VCHR_SRC NOT NULL VARCHAR2(4)
VAT_EXCPTN_TYPE NOT NULL VARCHAR2(1)
USER_VCHR_CHAR1 NOT NULL VARCHAR2(1)
USER_VCHR_CHAR2 NOT NULL VARCHAR2(1)
USER_VCHR_DEC NOT NULL NUMBER(26,3)
USER_VCHR_DATE DATE
USER_VCHR_NUM1 NOT NULL NUMBER(38)
USER_HDR_CHAR1 NOT NULL VARCHAR2(1)

Thanks and Regards,
Sumit

sumitgulati · Post by **sumitgulati** » Fri Aug 06, 2004 11:19 am

Sorry the ddl didn't come properly. Here is the post again:

Thanks for the suggestion guys but the error seems to be something else.

No the error is not system specific. I tried it from two different systems. Its gives the same error in both.

I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.

Here is the ddl for the table I am trying to import:

Code: Select all

Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 BUSINESS_UNIT                             NOT NULL VARCHAR2(5)
 VCHR_BLD_KEY_C1                           NOT NULL VARCHAR2(25)
 VCHR_BLD_KEY_C2                           NOT NULL VARCHAR2(25)
 VCHR_BLD_KEY_N1                           NOT NULL NUMBER(10)
 VCHR_BLD_KEY_N2                           NOT NULL NUMBER(10)
 VOUCHER_ID                                NOT NULL VARCHAR2(8)
 VOUCHER_STYLE                             NOT NULL VARCHAR2(4)
 INVOICE_ID                                NOT NULL VARCHAR2(30)
 INVOICE_DT                                NOT NULL DATE
 VENDOR_SETID                              NOT NULL VARCHAR2(5)
 VENDOR_ID                                 NOT NULL VARCHAR2(10)
 VNDR_LOC                                  NOT NULL VARCHAR2(10)
 ADDRESS_SEQ_NUM                           NOT NULL NUMBER(38)
 GRP_AP_ID                                 NOT NULL VARCHAR2(10)
 ORIGIN                                    NOT NULL VARCHAR2(3)
 OPRID                                     NOT NULL VARCHAR2(30)
 ACCOUNTING_DT                                      DATE
 POST_VOUCHER                              NOT NULL VARCHAR2(1)
 DST_CNTRL_ID                              NOT NULL VARCHAR2(10)
 VOUCHER_ID_RELATED                        NOT NULL VARCHAR2(8)
 GROSS_AMT                                 NOT NULL NUMBER(26,3)
 DSCNT_AMT                                 NOT NULL NUMBER(26,3)
 TAX_EXEMPT                                NOT NULL VARCHAR2(1)
 SALETX_AMT                                NOT NULL NUMBER(26,3)
 FREIGHT_AMT                               NOT NULL NUMBER(26,3)
 MISC_AMT                                  NOT NULL NUMBER(26,3)
 PYMNT_TERMS_CD                            NOT NULL VARCHAR2(5)
 ENTERED_DT                                         DATE
 TXN_CURRENCY_CD                           NOT NULL VARCHAR2(3)
 RT_TYPE                                   NOT NULL VARCHAR2(5)
 RATE_MULT                                 NOT NULL NUMBER(15,8)
 RATE_DIV                                  NOT NULL NUMBER(15,8)
 VAT_ENTRD_AMT                             NOT NULL NUMBER(26,3)
 MATCH_ACTION                              NOT NULL VARCHAR2(1)
 CUR_RT_SOURCE                             NOT NULL VARCHAR2(1)
 DSCNT_AMT_FLG                             NOT NULL VARCHAR2(1)
 DUE_DT_FLG                                NOT NULL VARCHAR2(1)
 VCHR_APPRVL_FLG                           NOT NULL VARCHAR2(1)
 BUSPROCNAME                               NOT NULL VARCHAR2(30)
 APPR_RULE_SET                             NOT NULL VARCHAR2(30)
 VAT_DCLRTN_POINT                          NOT NULL VARCHAR2(1)
 VAT_CALC_TYPE                             NOT NULL VARCHAR2(1)
 VAT_CALC_GROSS_NET                        NOT NULL VARCHAR2(1)
 VAT_RECALC_FLG                            NOT NULL VARCHAR2(1)
 VAT_CALC_FRGHT_FLG                        NOT NULL VARCHAR2(1)
 VAT_TREATMENT_GRP                         NOT NULL VARCHAR2(4)
 COUNTRY_SHIP_FROM                         NOT NULL VARCHAR2(3)
 STATE_SHIP_FROM                           NOT NULL VARCHAR2(6)
 COUNTRY_SHIP_TO                           NOT NULL VARCHAR2(3)
 STATE_SHIP_TO                             NOT NULL VARCHAR2(6)
 COUNTRY_VAT_BILLFR                        NOT NULL VARCHAR2(3)
 COUNTRY_VAT_BILLTO                        NOT NULL VARCHAR2(3)
 VAT_EXCPTN_CERTIF                         NOT NULL VARCHAR2(20)
 VAT_ROUND_RULE                            NOT NULL VARCHAR2(1)
 COUNTRY_LOC_SELLER                        NOT NULL VARCHAR2(3)
 STATE_LOC_SELLER                          NOT NULL VARCHAR2(6)
 COUNTRY_LOC_BUYER                         NOT NULL VARCHAR2(3)
 STATE_LOC_BUYER                           NOT NULL VARCHAR2(6)
 COUNTRY_VAT_SUPPLY                        NOT NULL VARCHAR2(3)
 STATE_VAT_SUPPLY                          NOT NULL VARCHAR2(6)
 COUNTRY_VAT_PERFRM                        NOT NULL VARCHAR2(3)
 STATE_VAT_PERFRM                          NOT NULL VARCHAR2(6)
 STATE_VAT_DEFAULT                         NOT NULL VARCHAR2(6)
 PREPAID_REF                               NOT NULL VARCHAR2(10)
 PREPAID_AUTO_APPLY                        NOT NULL VARCHAR2(1)
 DESCR254_MIXED                            NOT NULL VARCHAR2(254)
 EIN_FEDERAL                               NOT NULL VARCHAR2(9)
 EIN_STATE_LOCAL                           NOT NULL VARCHAR2(20)
 PROCESS_INSTANCE                          NOT NULL NUMBER(10)
 IN_PROCESS_FLG                            NOT NULL VARCHAR2(1)
 BUSINESS_UNIT_PO                          NOT NULL VARCHAR2(5)
 PO_ID                                     NOT NULL VARCHAR2(10)
 PACKSLIP_NO                               NOT NULL VARCHAR2(22)
 PAY_TRM_BSE_DT_OPT                        NOT NULL VARCHAR2(1)
 VAT_CALC_MISC_FLG                         NOT NULL VARCHAR2(1)
 IMAGE_REF_ID                              NOT NULL VARCHAR2(12)
 IMAGE_DATE                                         DATE
 PAY_SCHEDULE_TYPE                         NOT NULL VARCHAR2(3)
 TAX_GRP                                   NOT NULL VARCHAR2(4)
 TAX_PYMNT_TYPE                            NOT NULL VARCHAR2(5)
 INSPECT_DT                                         DATE
 INV_RECPT_DT                                       DATE
 RECEIPT_DT                                         DATE
 BILL_OF_LADING                            NOT NULL VARCHAR2(30)
 CARRIER_ID                                NOT NULL VARCHAR2(10)
 DOC_TYPE                                  NOT NULL VARCHAR2(8)
 DSCNT_DUE_DT                                       DATE
 DSCNT_PRORATE_FLG                         NOT NULL VARCHAR2(1)
 DUE_DT                                             DATE
 ECQUEUEINSTANCE                           NOT NULL NUMBER(38)
 ECTRANSID                                 NOT NULL VARCHAR2(15)
 FRGHT_CHARGE_CODE                         NOT NULL VARCHAR2(10)
 LC_ID                                     NOT NULL VARCHAR2(12)
 MISC_CHARGE_CODE                          NOT NULL VARCHAR2(10)
 REMIT_ADDR_SEQ_NUM                        NOT NULL NUMBER(38)
 SALETX_CHARGE_CODE                        NOT NULL VARCHAR2(10)
 VCHR_BLD_CODE                             NOT NULL VARCHAR2(6)
 BUSINESS_UNIT_AR                          NOT NULL VARCHAR2(5)
 CUST_ID                                   NOT NULL VARCHAR2(15)
 ITEM                                      NOT NULL VARCHAR2(30)
 ITEM_LINE                                 NOT NULL NUMBER(38)
 VCHR_SRC                                  NOT NULL VARCHAR2(4)
 VAT_EXCPTN_TYPE                           NOT NULL VARCHAR2(1)
 USER_VCHR_CHAR1                           NOT NULL VARCHAR2(1)
 USER_VCHR_CHAR2                           NOT NULL VARCHAR2(1)
 USER_VCHR_DEC                             NOT NULL NUMBER(26,3)
 USER_VCHR_DATE                                     DATE
 USER_VCHR_NUM1                            NOT NULL NUMBER(38)
 USER_HDR_CHAR1                            NOT NULL VARCHAR2(1)

Thanks and Regards,
Sumit