11 to 12 upgrade plexus error then how should I find customer_id error value

[ximen]

Please google translate the following

SQL Anywhere 卸载实用程序 版本 12.0.1.3457
正在连接并初始化
正在卸载用户和组定义
正在卸载表定义
正在卸载实例化视图定义
正在卸载索引定义
正在卸载函数
正在卸载视图定义
正在卸载过程
正在卸载触发器
正在卸载 SQL 远程定义
正在卸载 MobiLink 定义
正在创建新数据库
***** SQL 错误: 非法的列定义: 列 'customer_id' 的内置值 '100' 无效

[Breck_Carter]

Connecting and initialize
...
Uninstalling SQL remote definition
Uninstalling MobiLink definitions
We are creating a new database
***** SQL error: Illegal column definition: Column 'customer_id' built-in value '100' is not valid

Run dbunload -n, then search reload.sql for all the CREATE TABLE statements that contain customer_id and show them to us.

[Breck_Carter]

breck dot carter gmail

[ximen]

Please check your email. Thank you.

[Breck_Carter]

Nothing yet. If you attached a file, rename it from .sql to .txt

[Breck_Carter]

...and still nothing

[ximen]

E-mail has been sent successfully

[Breck_Carter]

Somehow the V12 dbunload produced a corrupt CREATE TABLE statement containing "varchar(10) NOT NULL INLINE 100 PREFIX 8" (see below)

Run dbunload to unload the schema and data, then edit reload.sql to remove the "INLINE 100 PREFIX 8", then run dbinit to create a new database, then run the reload.sql through dbisql to load the database.

Could not execute statement.
Illegal column definition: Column 'customer_id' inline value '100' is
invalid
SQLCODE=-1046, ODBC 3 State="42000"
Line 17189, column 1
You can continue executing or stop.

CREATE TABLE "DBA"."customer_fx" (
    "customer_id"                    varchar(10) NOT NULL INLINE 100 PREFIX 8
   ,"short_name"                     varchar(100) NULL
   ,"full_name"                      varchar(100) NULL
   ,"principal"                      varchar(50) NULL
   ,"linkman"                        varchar(50) NULL
   ,"telephone"                      varchar(30) NULL
   ,"facsimile"                      varchar(30) NULL
   ,"city"                           varchar(50) NULL
   ,"state"                          varchar(50) NULL
   ,"zipcode"                        varchar(15) NULL
   ,"country"                        varchar(50) NULL
   ,"e_mail"                         varchar(100) NULL
   ,"utl"                            varchar(100) NULL
   ,"customer_code"                  varchar(6) NOT NULL
   ,"credit_limit"                   numeric(16,6) NULL
   ,"bank_no"                        varchar(30) NULL
   ,"mob_no"                         varchar(16) NULL
   ,"cust_add"                       varchar(200) NULL
   ,"bank"                           varchar(60) NULL
   ,"salesman"                       varchar(10) NULL
   ,"quote_mode"                     varchar(6) NULL
   ,"open_date"                      date NULL
   ,"first_business_date"            date NULL
   ,"lately_business_date"           date NULL
   ,"capital"                        int NULL
   ,"annual_turnover"                int NULL
   ,"stuff_qty"                      int NULL
   ,"sell_code"                      varchar(1) NULL
   ,"credit_code"                    varchar(1) NULL
   ,"ar_account_id"                  varchar(25) NULL
   ,"price_term"                     varchar(50) NULL
   ,"primary_currency"               varchar(10) NULL
   ,"payment_term"                   varchar(50) NULL
   ,"transfer_mode"                  varchar(30) NULL
   ,"invoice_age"                    int NULL
   ,"credit_status"                  varchar(1) NULL
   ,"carrier_id"                     varchar(30) NULL
   ,"monthly_reckoning"              date NULL
   ,"remark"                         long varchar NULL
   ,"estimated_gathering"            date NULL
   ,"total_open_orders"              numeric(16,6) NULL
   ,"total_open_recv"                numeric(16,6) NULL
   ,"open_order_count"               int NULL
   ,"open_recv_count"                int NULL
   ,"foreign_customer"               varchar(30) NULL
   ,"user_1"                         varchar(30) NULL
   ,"user_2"                         varchar(30) NULL
   ,"user_3"                         varchar(100) NULL
   ,"user_4"                         varchar(30) NULL
   ,"user_5"                         varchar(30) NULL
   ,"user_6"                         numeric(16,6) NULL
   ,"user_7"                         numeric(16,6) NULL
   ,"user_8"                         numeric(16,6) NULL
   ,"user_9"                         numeric(16,6) NULL
   ,"user_10"                        numeric(16,6) NULL
   ,"business_no"                    varchar(30) NULL
   ,"artifical_person"               varchar(10) NULL
   ,"tax_register"                   varchar(30) NULL
   ,"create_time"                    timestamp NULL DEFAULT current timestamp
   ,"edit_time"                      timestamp NULL DEFAULT timestamp
   ,"pre_accept_amt"                 numeric(16,6) NULL
   ,"should_accept_amt"              numeric(16,6) NULL
   ,"owe_accept_amt"                 numeric(16,6) NULL
   ,"grade"                          varchar(10) NULL
   ,"card_id"                        varchar(10) NULL
   ,"card_no"                        varchar(15) NULL
   ,"tax_id"                         varchar(10) NULL
   ,"region_id"                      varchar(10) NULL
   ,"sell_grade"                     varchar(10) NULL
   ,"lately_follow_date"             date NULL
   ,"receivable_acct_id"             varchar(30) NULL
   ,"precash_acct_id"                varchar(30) NULL
   ,"vendor_id"                      varchar(10) NULL
   ,"discount_id"                    varchar(10) NULL
   ,"integral"                       decimal(16,6) NULL
   ,"acount_date"                    int NULL
   ,"locked"                         varchar(1) NULL
   ,"lock_man"                       varchar(10) NULL
   ,"lock_time"                      timestamp NULL
   ,"upper_cust_id"                  varchar(10) NULL
   ,"salesdept"                      varchar(10) NULL
   ,"cust_name_of_invoice"           varchar(100) NULL
   ,"cust_addr_of_invoice"           varchar(200) NULL
   ,"cust_tel_of_invoice"            varchar(30) NULL
   ,"cust_fax_of_invoice"            varchar(30) NULL
   ,"protocol_no"                    varchar(30) NULL
   ,"invoicedays"                    int NULL
   ,"post_of_invoice"                varchar(15) NULL
   ,"man_of_invoice"                 varchar(10) NULL
   ,"post_addr_of_invoice"           varchar(200) NULL
   ,"goods_with_invoice"             varchar(1) NULL
   ,"others_of_invoice"              varchar(200) NULL
   ,"user_11"                        varchar(50) NULL
   ,"user_12"                        varchar(50) NULL
   ,"user_13"                        varchar(50) NULL
   ,"user_14"                        varchar(50) NULL
   ,"user_15"                        varchar(50) NULL
   ,"qq_number"                      varchar(30) NULL
   ,"rec_other"                      varchar(30) NULL
   ,"progress_status"                varchar(10) NULL
   ,"mob_no2"                        varchar(16) NULL
   ,"first_contact_date"             date NULL
   ,"service_start_date"             date NULL
   ,"service_end_date"               date NULL
   ,"service_price"                  decimal(16,6) NULL
   ,"abandon_reason"                 varchar(400) NULL
   ,"if_abandon"                     varchar(1) NULL
   ,"salesman2"                      varchar(10) NULL
   ,"serve_man1"                     varchar(10) NULL
   ,"serve_man2"                     varchar(10) NULL
   ,"location_id"                    char(15) NULL
   ,"deliver_man"                    char(30) NULL
   ,"driver"                         char(30) NULL
   ,"car_no"                         char(30) NULL
   ,"channel_id"                     varchar(10) NULL
   ,"web_id"                         varchar(50) NULL
   ,"sum_ensemble"                   char(1) NULL
   ,"if_inside_custvend"             char(1) NULL
   ,"rec_sign"                       char(30) NULL
   ,"if_local"                       char(1) NULL
   ,PRIMARY KEY ("customer_id") 
)