[PB] Data Pipeline pipelineobject. Start Error List

Source: Internet
Author: User
Tags sql error

Integer. Returns 1 if it succeeds and a negative number if an error occurs.
Error values are:
-1 pipe open failed
-2 too partition Columns
-3 table already exists
-4 table does not exist
-5 missing connection
-6 wrong arguments
-7 column Mismatch
-8 fatal SQL error in Source
-9 fatal SQL error in destination
-10 maximum number of errors exceeded
-12 bad table syntax
-13 key required but not supplied
-15 pipe already in progress
-16 error in source database
-17 error in destination Database
-18 Destination database is read-only

If any argument's value is NULL, Start returns NULL.

String ls_errortext

IF IsNull (ai_ErrCode) THEN
Ls_errortext = "null parameter passed! "
RETURN''
END IF

Choose case ai_ErrCode
CASE-1
Ls_errortext = "An error occurred while opening the data pipeline! Check whether all objects are valid. Error Code: "+ String (ai_ErrCode)
CASE-2
Ls_errortext = "the number of columns exceeds the upper limit! Error Code: "+ String (ai_ErrCode)
CASE-3
Ls_errortext = "the target table already exists! Error Code: "+ String (ai_ErrCode)
CASE-4
Ls_errortext = "the target table does not exist! Error Code: "+ String (ai_ErrCode)
CASE-5 // common start () function and repair () function common error code
Ls_errortext = "the connection is disconnected! Error Code: "+ String (ai_ErrCode)
CASE-6
Ls_errortext = "error parameter! "
CASE-7
Ls_errortext = "the column type does not match! Error Code: "+ String (ai_ErrCode)
CASE-8
Ls_errortext = "source SQL syntax error! Error Code: "+ String (ai_ErrCode)
CASE-9 // common
Ls_errortext = "the target SQL syntax is incorrect! Error Code: "+ String (ai_errcode)
Case-10 // common
Ls_errortext = "the number of errors exceeds the maximum number of errors defined! Error Code: "+ String (ai_errcode)
Case-11 // repair error code
Ls_errortext = "Invalid Window handle! Error Code: "+ String (ai_errcode)
Case-12 // common
Ls_errortext = "Incorrect table syntax! Error Code: "+ String (ai_errcode)
Case-13
Ls_errortext = "null primary key value! Error Code: "+ String (ai_errcode)
Case-15 // common
Ls_errortext = "this data pipeline has been opened! Error Code: "+ String (ai_errcode)
Case-16
Ls_errortext = "the error occurs in the source database! Error Code: "+ String (ai_errcode)
Case-17 // common
Ls_errortext = "the error occurs in the target database! Error Code: "+ String (ai_errcode)
Case-18 // common
Ls_errortext = "target database read-only! Error Code: "+ String (ai_errcode)
End choose

Return ls_errortext

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.