Apatar Community Forums

how to start scheduler from linux without GUI

Anonymous — Thu, 09 Feb 2012 01:44:40 GMT

can we start the Scheduler in Linux, as a background service?
i do not have the GUI version if linux.

SpareRoom (Furqankhan)

sanabatool — Tue, 07 Feb 2012 09:35:09 GMT

Find a flatshare or flatmate fast! 1000s of rooms for rent in flatshares across London, Manchester, Birmingham, Bristol, Leeds, Edinburgh, Glasgow and the rest. http://www.spareroom.co.uk

start a new download

digo12 — Tue, 07 Feb 2012 03:47:51 GMT

Hello!,

I would like to use apatar in MSQL we're using. I have problems starting apatar after download. Can someone help me pls.

Maybe I need something as well.

Thank you,

Free alternative?

shayhurst — Mon, 06 Feb 2012 12:00:06 GMT

Since it seems that Apatar is no longer being supported (several unanswered forum posts, several unanswered emails) does anyone know of a similar free tool which I can use instead?

Salesforce to Excel - no records inserted

Anonymous — Sun, 05 Feb 2012 04:01:45 GMT

I've created a salesforce connector using insert mode. I previewed it and the data is as expected. I connect this to the excel connector using insert mode to worksheet 3. The record source parameters are: offset=1 and first fieldname is checked. The worksheet contains 1 row which is the header information. When I preview the results, no records are processed.

This is the error log.
Start date Sat Feb 04 22:49:59 EST 2012
Version Apatar_v1.12.23
JRE Version 1.6.0_24
JRE Vendor Sun Microsystems Inc.
Encoding Cp1252
log4j.configuration = `file:/C:/Program%20Files/Apatar/log4j.properties`
Start Reading from Account
java.lang.ClassCastException: com.apatar.core.Record cannot be cast to com.apatar.msexcel.MsExcelRecord
at com.apatar.msexcel.MsExcelNode.insertTDBtoRDB(MsExcelNode.java:388)
at com.apatar.msexcel.MsExcelNode.insertTDBtoRDB(MsExcelNode.java:360)
at com.apatar.msexcel.MsExcelNode.TransformTDBtoRDB(MsExcelNode.java:332)
at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:369)
at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:335)
at com.apatar.core.Runnable.execute(Runnable.java:270)
at com.apatar.core.Runnable.execute(Runnable.java:250)
at com.apatar.core.Runnable.execute(Runnable.java:244)
at com.apatar.core.Runnable.executeToNode(Runnable.java:237)
at com.apatar.core.Runnable.access$0(Runnable.java:234)
at com.apatar.core.Runnable$Run.run(Runnable.java:107)

What am I doing wrong? I don't know whether this is relevant but I'm using MS Excel 2002.

Rose

Need to parse an address field into separate components

chitro — Sat, 04 Feb 2012 00:03:33 GMT

Hello:

We are a new Apatar user and are using it to load values from a CSV to a mysql table.

Problem is - our input address field (only US for now) comes as one string and we need to store it into the standard components e.g. Street Address, City, State, Zip. An example is:

City Center Building 1200 Dorothy Way Brooklyn, NY 11229

So we need to get:
Steet Address: City Center Building 1200 Dorothy Way
City: Brooklyn
State: NY
Zip: 11229

Is there a string token (strtok) type function which we can use to parse these elements? Please help.

Regards.

Chitro

getting a java.lang.nullpointerexpception error when datamap

egrill — Mon, 30 Jan 2012 21:41:28 GMT

I am getting a java.lang.nullpointerexception message when I am trying to connect to Sugarcrm.

I can't connect to the Sugarcrm.

Any assistance would be helpful.

Endless Salesforce upload never inserts a record

shayhurst — Mon, 30 Jan 2012 09:39:03 GMT

Hello,
I am having a problem with the Salesforce connector. I had this same problem with my Opportunity Line Items and the issue was because there was no external Id in my data. However that doesn't appear to be the case in this situation. As you can see from this screenshot, I have a row which is about to be passed to the last SF connection:

One of these rows is QUOTE_NUMBER_CD__C which as you can see from this screenshot, is an externalId in Salesforce:

However, the last connection, which is set to Update Mode with QUOTE_NUMBER_CD__C selected, doesn�t attempt to pass any records to SF. Instead it creates a batch that never ends and never lists any records or shows any error:

The output log is below, as is the error log � I can�t see any obvious error. If you could advise me I�d appreciate it as I am desperate to get this working otherwise I may have to stop using this tool as I have been trying for a number of weeks to get this up and running.

I have attempted to insert these records into SF using the Apex Data Loader and it inserted without a problem � indicating to me that the data is fine and the issue is somewhere in Apatar.

Error Log

Code:

Start date Thu Jan 26 16:13:48 GMT 2012
Version Apatar_v1.12.23
JRE Version 1.6.0_13
JRE Vendor Sun Microsystems Inc.
Encoding Cp1252
log4j.configuration = `file:/C:/Program%20Files/Apatar/log4j.properties`
Start Reading from Opportunity
Start Reading from Account
Start Reading from quoteheader.csv
Row '' has incorrect length.
Start Reading from Opportunity

Output

Code:

*********************************
Start date Thu Jan 26 16:13:48 GMT 2012
Version Apatar_v1.12.23
JRE Version 1.6.0_13
JRE Vendor Sun Microsystems Inc.
Encoding Cp1252
log4j.configuration = `file:/C:/Program%20Files/Apatar/log4j.properties`
user.dir= `C:\Program Files\Apatar`
Configuration database closed.
jdbc:derby:C:/Program Files/Apatar/tempdb/application/temp_db;create=true
Logs cleared.
******************* Start Time = Thu Jan 26 16:13:55 GMT 2012
CREATE TABLE temp991922559300486005 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "ORIGID__c" VARCHAR(54), "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "Proposal_Engineer__c" VARCHAR(18), "Stra__TrackingNumber__c" VARCHAR(36), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "In_strip__c" SMALLINT, "Quote_Required_Date__c" DATE, "Quote_Required_By_Date__c" DATE, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900))
Trying to DROP table before creating it. Table name `temp991922559300486005`
Failed to drop table `temp991922559300486005`
Table `temp991922559300486005` created successfully
UI query: `INSERT %post_insert% INTO temp991922559300486005 ("QUOTE_NUMBER_CD__c", "Id") VALUES (?, ?)`
UI query: `INSERT %post_insert% INTO temp991922559300486005 ("QUOTE_NUMBER_CD__c", "Id") VALUES (?, ?)`
CREATE TABLE temp3642585227516949250 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "MasterRecordId" VARCHAR(18), "Name" VARCHAR(765), "Type" VARCHAR(120), "ParentId" VARCHAR(18), "BillingStreet" VARCHAR(765), "BillingCity" VARCHAR(120), "BillingState" VARCHAR(60), "BillingPostalCode" VARCHAR(60), "BillingCountry" VARCHAR(120), "ShippingStreet" VARCHAR(765), "ShippingCity" VARCHAR(120), "ShippingState" VARCHAR(60), "ShippingPostalCode" VARCHAR(60), "ShippingCountry" VARCHAR(120), "Phone" VARCHAR(120), "Fax" VARCHAR(120), "AccountNumber" VARCHAR(120), "Website" VARCHAR(765), "Sic" VARCHAR(60), "Industry" VARCHAR(240), "AnnualRevenue" DOUBLE, "NumberOfEmployees" BIGINT, "Ownership" VARCHAR(120), "TickerSymbol" VARCHAR(60), "Description" VARCHAR(32000), "Rating" VARCHAR(120), "Site" VARCHAR(240), "CurrencyIsoCode" VARCHAR(9), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Account_Agent__c" VARCHAR(765), "Account_Number__c" VARCHAR(120), "Account_Site_Ownership__c" VARCHAR(765), "Account_Status__c" VARCHAR(765), "Annual_Spend_on_Power_Transmissions__c" DOUBLE, "Applications__c" VARCHAR(4099), "Attractiveness_New_Customers__c" VARCHAR(765), "Attractiveness__c" VARCHAR(765), "Budget_Per_Day__c" DOUBLE, "Budget__c" DOUBLE, "CSAT_Average_Score__c" DOUBLE, "Channel__c" VARCHAR(765), "Competitor__c" VARCHAR(4099), "Credit_Limit__c" DOUBLE, "Credit_Notes__c" DOUBLE, "Current_Orderbook__c" DOUBLE, "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Incoterms_2010__c" VARCHAR(765), "Internal_External__c" VARCHAR(765), "FN__Find_Nearby__c" VARCHAR(3900), "Last_Years_Orders__c" DOUBLE, "Last_Years_Sales__c" DOUBLE, "FN__Lat__c" DOUBLE, "Source__c" VARCHAR(765), "FN__Lon__c" DOUBLE, "No_Of_Employees__c" VARCHAR(765), "Payment_Terms__c" VARCHAR(180), "Price_Code__c" VARCHAR(36), "Territory_Number__c" VARCHAR(12), "This_Years_Orders__c" DOUBLE, "This_Years_Sales__c" DOUBLE, "VAT_Number__c" VARCHAR(60), "FN__Mapping_Status__c" VARCHAR(765), "RSF__c" DOUBLE, "Total_Order_Price__c" DOUBLE, "ORIGID__c" VARCHAR(54), "FN__Which_Address__c" VARCHAR(765), "Owner_Name__c" VARCHAR(765), "HooversId__c" VARCHAR(60), "D_U_N_S__c" VARCHAR(60), "Opps_won__c" DOUBLE, "Opps_lost__c" DOUBLE, "opps_dead__c" DOUBLE, "Opps_won_perc__c" DOUBLE, "Quoted_Closed__c" DOUBLE, "Opps_lost_Perc__c" DOUBLE, "Opps_dead_Perc__c" DOUBLE, "Opps_not_quoted__c" DOUBLE, "Quoted_Open__c" DOUBLE, "Default_BU_CoE__c" VARCHAR(765), "Quote_rating__c" VARCHAR(3900), "Sales_Region__c" VARCHAR(18), "Stra__stratus_sharepointurl__c" VARCHAR(765), "Stra__stratus_usesharepointonline__c" SMALLINT)
Trying to DROP table before creating it. Table name `temp3642585227516949250`
Failed to drop table `temp3642585227516949250`
Table `temp3642585227516949250` created successfully
UI query: `INSERT %post_insert% INTO temp3642585227516949250 ("Account_Number__c", "Id") VALUES (?, ?)`
CREATE TABLE temp7670619728634295853 ("Quote_Number__c" LONG VARCHAR, "OwnerId" LONG VARCHAR, "Quote_Status__c" LONG VARCHAR, "Customer_Ref__c" LONG VARCHAR, "Received_Date__c" LONG VARCHAR, "AccountId" LONG VARCHAR, "Date_Quoted__c" LONG VARCHAR, "Name" LONG VARCHAR, "CloseDate" LONG VARCHAR, "StageName" LONG VARCHAR, "CurrencyIsoCode" LONG VARCHAR, "Country__c" LONG VARCHAR, "Industryoc__c" LONG VARCHAR, "Type__c" LONG VARCHAR, "Application__c" LONG VARCHAR, "Channel__c" LONG VARCHAR, "Product__c" LONG VARCHAR, "Country_Cust__c" LONG VARCHAR)
Trying to DROP table before creating it. Table name `temp7670619728634295853`
Failed to drop table `temp7670619728634295853`
Table `temp7670619728634295853` created successfully
CREATE TABLE quoteheader.csv ("Quote_Number__c" LONG VARCHAR, "OwnerId" LONG VARCHAR, "Quote_Status__c" LONG VARCHAR, "Customer_Ref__c" LONG VARCHAR, "Received_Date__c" LONG VARCHAR, "AccountId" LONG VARCHAR, "Date_Quoted__c" LONG VARCHAR, "Name" LONG VARCHAR, "CloseDate" LONG VARCHAR, "StageName" LONG VARCHAR, "CurrencyIsoCode" LONG VARCHAR, "Country__c" LONG VARCHAR, "Industryoc__c" LONG VARCHAR, "Type__c" LONG VARCHAR, "Application__c" LONG VARCHAR, "Channel__c" LONG VARCHAR, "Product__c" LONG VARCHAR, "Country_Cust__c" LONG VARCHAR)
\\Txpdsphud001\ERPDATA\Traverse City\Salesforce\quoteheader.csv
Table `quoteheader.csv` created successfully
\\Txpdsphud001\ERPDATA\Traverse City\Salesforce\quoteheader.csv
UI query: `INSERT %post_insert% INTO temp7670619728634295853 ("Quote_Number__c", "OwnerId", "Quote_Status__c", "Customer_Ref__c", "Received_Date__c", "AccountId", "Date_Quoted__c", "Name", "CloseDate", "StageName", "CurrencyIsoCode", "Country__c", "Industryoc__c", "Type__c", "Application__c", "Channel__c", "Product__c", "Country_Cust__c") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp7804712037904436758 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "Application_Status__c" VARCHAR(765), "ORIGID__c" VARCHAR(54), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "Programme_Manger__c" VARCHAR(765), "Proposals_Engineer__c" VARCHAR(765), "Proposals_Status__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Related_Campaign__c" VARCHAR(765), "Sales_Status__c" VARCHAR(765), "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Status__c" VARCHAR(240), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "rep_ProductTypeLegend__c" VARCHAR(3900), "Proposal_Engineer__c" VARCHAR(18), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "RSM_approver__c" VARCHAR(18), "Approval_Mgr__c" VARCHAR(18), "In_strip__c" SMALLINT, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900), "AU_Sales_review_date_in__c" DATE, "AU_Sales_review_date_out__c" DATE, "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Stra__TrackingNumber__c" VARCHAR(36))
Trying to DROP table before creating it. Table name `temp7804712037904436758`
Failed to drop table `temp7804712037904436758`
Table `temp7804712037904436758` created successfully
UI query: `INSERT %post_insert% INTO temp7804712037904436758 ("StageName", "CurrencyIsoCode", "Channel__c", "OwnerId", "Industryoc__c", "Country__c", "Country_cust__c", "Received_Date__c", "Customer_Ref__c", "Name", "Date_Quoted__c", "AccountId", "Application__c", "Product__c", "QUOTE_NUMBER_CD__c", "Type__c", "Quote_Status__c", "CloseDate") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp7245912281512589399 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "Application_Status__c" VARCHAR(765), "ORIGID__c" VARCHAR(54), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "Programme_Manger__c" VARCHAR(765), "Proposals_Engineer__c" VARCHAR(765), "Proposals_Status__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Related_Campaign__c" VARCHAR(765), "Sales_Status__c" VARCHAR(765), "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Status__c" VARCHAR(240), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "rep_ProductTypeLegend__c" VARCHAR(3900), "Proposal_Engineer__c" VARCHAR(18), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "RSM_approver__c" VARCHAR(18), "Approval_Mgr__c" VARCHAR(18), "In_strip__c" SMALLINT, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900), "AU_Sales_review_date_in__c" DATE, "AU_Sales_review_date_out__c" DATE, "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Stra__TrackingNumber__c" VARCHAR(36))
Trying to DROP table before creating it. Table name `temp7245912281512589399`
Failed to drop table `temp7245912281512589399`
Table `temp7245912281512589399` created successfully
join query `select temp3642585227516949250."Id" as temp3642585227516949250_Id, temp7804712037904436758."Application__c" as temp7804712037904436758_Application__c, temp7804712037904436758."Channel__c" as temp7804712037904436758_Channel__c, temp7804712037904436758."CloseDate" as temp7804712037904436758_CloseDate, temp7804712037904436758."Country__c" as temp7804712037904436758_Country__c, temp7804712037904436758."Country_cust__c" as temp7804712037904436758_Country_cust__c, temp7804712037904436758."CurrencyIsoCode" as temp7804712037904436758_CurrencyIsoCode, temp7804712037904436758."Customer_Ref__c" as temp7804712037904436758_Customer_Ref__c, temp7804712037904436758."Date_Quoted__c" as temp7804712037904436758_Date_Quoted__c, temp7804712037904436758."Industryoc__c" as temp7804712037904436758_Industryoc__c, temp7804712037904436758."Name" as temp7804712037904436758_Name, temp7804712037904436758."OwnerId" as temp7804712037904436758_OwnerId, temp7804712037904436758."Product__c" as temp7804712037904436758_Product__c, temp7804712037904436758."QUOTE_NUMBER_CD__c" as temp7804712037904436758_QUOTE_NUMBER_CD__c, temp7804712037904436758."Received_Date__c" as temp7804712037904436758_Received_Date__c, temp7804712037904436758."Quote_Status__c" as temp7804712037904436758_Quote_Status__c, temp7804712037904436758."Type__c" as temp7804712037904436758_Type__c, temp7804712037904436758."StageName" as temp7804712037904436758_StageName from temp3642585227516949250 inner join temp7804712037904436758 on temp7804712037904436758."AccountId" = temp3642585227516949250."Account_Number__c"`
UI query: `INSERT %post_insert% INTO temp7245912281512589399 ("StageName", "CurrencyIsoCode", "Channel__c", "OwnerId", "Industryoc__c", "Country__c", "Country_cust__c", "Received_Date__c", "Customer_Ref__c", "Name", "Date_Quoted__c", "AccountId", "Application__c", "Product__c", "QUOTE_NUMBER_CD__c", "Type__c", "Quote_Status__c", "CloseDate") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp5412060916747881544 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "ORIGID__c" VARCHAR(54), "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "Proposal_Engineer__c" VARCHAR(18), "Stra__TrackingNumber__c" VARCHAR(36), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "In_strip__c" SMALLINT, "Quote_Required_Date__c" DATE, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900), "Application_Status__c" VARCHAR(765), "Programme_Manger__c" VARCHAR(765), "Proposals_Engineer__c" VARCHAR(765), "Proposals_Status__c" VARCHAR(765), "Related_Campaign__c" VARCHAR(765), "Sales_Status__c" VARCHAR(765), "Status__c" VARCHAR(240), "rep_ProductTypeLegend__c" VARCHAR(3900), "RSM_approver__c" VARCHAR(18), "Approval_Mgr__c" VARCHAR(18), "AU_Sales_review_date_in__c" DATE, "AU_Sales_review_date_out__c" DATE)
Trying to DROP table before creating it. Table name `temp5412060916747881544`
Failed to drop table `temp5412060916747881544`
Table `temp5412060916747881544` created successfully
join query `select temp991922559300486005."Id" as temp991922559300486005_Id, temp7245912281512589399."AccountId" as temp7245912281512589399_AccountId, temp7245912281512589399."CloseDate" as temp7245912281512589399_CloseDate, temp7245912281512589399."Country__c" as temp7245912281512589399_Country__c, temp7245912281512589399."Application__c" as temp7245912281512589399_Application__c, temp7245912281512589399."Channel__c" as temp7245912281512589399_Channel__c, temp7245912281512589399."Customer_Ref__c" as temp7245912281512589399_Customer_Ref__c, temp7245912281512589399."Date_Quoted__c" as temp7245912281512589399_Date_Quoted__c, temp7245912281512589399."Country_cust__c" as temp7245912281512589399_Country_cust__c, temp7245912281512589399."CurrencyIsoCode" as temp7245912281512589399_CurrencyIsoCode, temp7245912281512589399."Name" as temp7245912281512589399_Name, temp7245912281512589399."Industryoc__c" as temp7245912281512589399_Industryoc__c, temp7245912281512589399."Product__c" as temp7245912281512589399_Product__c, temp7245912281512589399."OwnerId" as temp7245912281512589399_OwnerId, temp7245912281512589399."QUOTE_NUMBER_CD__c" as temp7245912281512589399_QUOTE_NUMBER_CD__c, temp7245912281512589399."Received_Date__c" as temp7245912281512589399_Received_Date__c, temp7245912281512589399."Quote_Status__c" as temp7245912281512589399_Quote_Status__c, temp7245912281512589399."Type__c" as temp7245912281512589399_Type__c, temp7245912281512589399."StageName" as temp7245912281512589399_StageName from temp991922559300486005 right join temp7245912281512589399 on temp7245912281512589399."QUOTE_NUMBER_CD__c" = temp991922559300486005."QUOTE_NUMBER_CD__c"`
UI query: `INSERT %post_insert% INTO temp5412060916747881544 ("StageName", "CurrencyIsoCode", "Channel__c", "OwnerId", "Industryoc__c", "Country__c", "Country_cust__c", "Received_Date__c", "Customer_Ref__c", "Name", "Date_Quoted__c", "AccountId", "Application__c", "Product__c", "QUOTE_NUMBER_CD__c", "Type__c", "Quote_Status__c", "Id", "CloseDate") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp1151346580332170917True ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "ORIGID__c" VARCHAR(54), "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "Proposal_Engineer__c" VARCHAR(18), "Stra__TrackingNumber__c" VARCHAR(36), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "In_strip__c" SMALLINT, "Quote_Required_Date__c" DATE, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900), "Application_Status__c" VARCHAR(765), "Programme_Manger__c" VARCHAR(765), "Proposals_Engineer__c" VARCHAR(765), "Proposals_Status__c" VARCHAR(765), "Related_Campaign__c" VARCHAR(765), "Sales_Status__c" VARCHAR(765), "Status__c" VARCHAR(240), "rep_ProductTypeLegend__c" VARCHAR(3900), "RSM_approver__c" VARCHAR(18), "Approval_Mgr__c" VARCHAR(18), "AU_Sales_review_date_in__c" DATE, "AU_Sales_review_date_out__c" DATE)
Trying to DROP table before creating it. Table name `temp1151346580332170917True`
Failed to drop table `temp1151346580332170917True`
Table `temp1151346580332170917True` created successfully
UI query: `INSERT %post_insert% INTO temp1151346580332170917True ("Win_strategy__c", "Product_Sub_Group__c", "Feedback_Notes__c", "Proposals_Status__c", "Job_No__c", "LastModifiedDate", "Application_Status__c", "LeadSource", "Project_On_Hold__c", "Rep_RecType__c", "Timer_Start_Stage_R3__c", "OpportunityValue__c", "Application_Engineer__c", "Timer_Start_stage_R2__c", "ForecastCategoryName", "timer_inStrip__c", "Quote_Required_Date__c", "Stage_explanation__c", "Channel__c", "Timer_StartAppEngDT__c", "ExpectedRevenue", "TotalOpportunityQuantity", "With_app_engineer__c", "China_Account_Owner__c", "Manufacturing_Due_Date__c", "Stra__Account_SP_Enabled__c", "Preferred__c", "Product__c", "CreatedById", "With_Proposal_Eng__c", "Proposals_Engineer__c", "IsDeleted", "Quote_Status__c", "CloseDate", "SalesManager__c", "Reason_Won_Lost__c", "Timer_Estimating__c", "Primary_Competitor__c", "OwnerId", "Expected_Margin__c", "IsPrivate", "Country_cust__c", "Sum_products__c", "Budget_quote__c", "SystemModstamp", "Timer_Start_Stage_R6__c", "Sales_Status__c", "Manufacturing_Delivery__c", "DBGS_13_Digit_Code__c", "Stra__Stratus_Sharepointurl__c", "With_Estimator__c", "Business_Unit__c", "AU_Sales_review_date_in__c", "Time_in_Stage_R6__c", "Industryoc__c", "Timer_Start_Stage_R1__c", "Approval_Mgr__c", "Customer_Ref__c", "Received_Date__c", "Date_Quoted__c", "Application__c", "CreatedDate", "QUOTE_NUMBER_CD__c", "AU_Sales_review_date_out__c", "Timer_Start_Stage_R5__c", "Timer_Start_Proposal__c", "Time_inStrip__c", "Dead_reason__c", "Probability", "RecordTypeId", "NextStep", "Days_in_strip__c", "Days_with_App_Engineer__c", "Pricebook2Id", "Priority_rating__c", "Time_Waited_For_Supplier__c", "Quote_Number__c", "Project_stage__c", "IsClosed", "Related_Campaign__c", "Days_with_Proposal_Eng__c", "In_strip__c", "Time_in_Stage_R2__c", "Waiting_for_supplier__c", "Time_in_Stage_R4__c", "Stra__TrackingNumber__c", "Timer_Start_Stage_R4__c", "ORIGID__c", "Amount", "CurrencyIsoCode", "Days_with_Estimator__c", "NOP__c", "Programme_Manger__c", "Time_Estimating__c", "Country__c", "Estimator__c", "Timer_Start_Applic_Eng__c", "Timer_StartWaitForSupp__c", "HasOpportunityLineItem", "AccountId", "Order_No__c", "Fiscal_Period__c", "Id", "TimeWaitedForCust__c", "Status__c", "rep_ProductTypeLegend__c", "IsWon", "Order_to_place__c", "Project__c", "Time_in_Stage_R1__c", "Type", "Timer_WaitForCust__c", "RSM_approver__c", "Data_Quality_Score__c", "Competitor_Price__c", "Customer_Part_No__c", "Time_with_Proposal_Eng__c", "LastActivityDate", "Waiting_for_cust__c", "OTP_Preferred__c", "Time_in_Stage_R3__c", "ForecastCategory", "Age_Date_Received__c", "StageName", "Description", "LastModifiedById", "Proposal_Engineer__c", "Time_in_Stage_R5__c", "Name", "CampaignId", "Time_Taken__c", "Time_WithAppEng__c", "Reporting_label__c", "Priority_number__c", "Type__c", "Data_Quality_Description__c") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp7804712037904436758 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "ORIGID__c" VARCHAR(54), "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "Proposal_Engineer__c" VARCHAR(18), "Stra__TrackingNumber__c" VARCHAR(36), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "In_strip__c" SMALLINT, "Quote_Required_Date__c" DATE, "Quote_Required_By_Date__c" DATE, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900), "Application_Status__c" VARCHAR(765), "Programme_Manger__c" VARCHAR(765), "Proposals_Engineer__c" VARCHAR(765), "Proposals_Status__c" VARCHAR(765), "Related_Campaign__c" VARCHAR(765), "Sales_Status__c" VARCHAR(765), "Status__c" VARCHAR(240), "rep_ProductTypeLegend__c" VARCHAR(3900), "RSM_approver__c" VARCHAR(18), "Approval_Mgr__c" VARCHAR(18), "AU_Sales_review_date_in__c" DATE, "AU_Sales_review_date_out__c" DATE)
Trying to DROP table before creating it. Table name `temp7804712037904436758`
Table `temp7804712037904436758` dropped successfully
Table `temp7804712037904436758` created successfully
UI query: `INSERT %post_insert% INTO temp7804712037904436758 ("StageName", "CurrencyIsoCode", "Channel__c", "OwnerId", "Industryoc__c", "Country__c", "Country_cust__c", "Received_Date__c", "Customer_Ref__c", "Name", "Date_Quoted__c", "AccountId", "Application__c", "Product__c", "QUOTE_NUMBER_CD__c", "Type__c", "Quote_Status__c", "CloseDate") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
CREATE TABLE temp5458532393141619885 ("Id" VARCHAR(18), "IsDeleted" SMALLINT, "AccountId" VARCHAR(18), "RecordTypeId" VARCHAR(18), "IsPrivate" SMALLINT, "Name" VARCHAR(360), "Description" VARCHAR(32000), "StageName" VARCHAR(120), "Amount" DOUBLE, "Probability" DOUBLE, "ExpectedRevenue" DOUBLE, "TotalOpportunityQuantity" DOUBLE, "CloseDate" DATE, "Type" VARCHAR(120), "NextStep" VARCHAR(765), "LeadSource" VARCHAR(120), "IsClosed" SMALLINT, "IsWon" SMALLINT, "ForecastCategory" VARCHAR(120), "ForecastCategoryName" VARCHAR(120), "CurrencyIsoCode" VARCHAR(9), "CampaignId" VARCHAR(18), "HasOpportunityLineItem" SMALLINT, "Pricebook2Id" VARCHAR(18), "OwnerId" VARCHAR(18), "CreatedDate" TIMESTAMP, "CreatedById" VARCHAR(18), "LastModifiedDate" TIMESTAMP, "LastModifiedById" VARCHAR(18), "SystemModstamp" TIMESTAMP, "LastActivityDate" DATE, "Age_Date_Received__c" DOUBLE, "ORIGID__c" VARCHAR(54), "Stra__Account_SP_Enabled__c" VARCHAR(3900), "Channel__c" VARCHAR(765), "China_Account_Owner__c" VARCHAR(90), "Competitor_Price__c" VARCHAR(765), "Country__c" VARCHAR(765), "Customer_Part_No__c" VARCHAR(300), "Customer_Ref__c" VARCHAR(150), "Data_Quality_Description__c" VARCHAR(3900), "Data_Quality_Score__c" DOUBLE, "Date_Quoted__c" DATE, "Expected_Margin__c" DOUBLE, "Feedback_Notes__c" LONG VARCHAR, "Priority_number__c" DOUBLE, "Industryoc__c" VARCHAR(765), "Job_No__c" VARCHAR(300), "With_Estimator__c" SMALLINT, "Manufacturing_Delivery__c" DOUBLE, "Manufacturing_Due_Date__c" DATE, "NOP__c" DOUBLE, "With_Proposal_Eng__c" SMALLINT, "Order_No__c" VARCHAR(60), "Primary_Competitor__c" VARCHAR(765), "Product_Sub_Group__c" VARCHAR(6), "Product__c" VARCHAR(765), "QUOTE_NUMBER_CD__c" VARCHAR(120), "Quote_Number__c" VARCHAR(90), "Quote_Status__c" VARCHAR(765), "Timer_Estimating__c" DATE, "Time_Estimating__c" DOUBLE, "Reason_Won_Lost__c" VARCHAR(765), "Received_Date__c" DATE, "Time_Taken__c" DOUBLE, "Type__c" VARCHAR(765), "Time_WithAppEng__c" DOUBLE, "Timer_StartAppEngDT__c" TIMESTAMP, "DBGS_13_Digit_Code__c" VARCHAR(150), "Application__c" VARCHAR(765), "OpportunityValue__c" DOUBLE, "SalesManager__c" VARCHAR(18), "Stra__Stratus_Sharepointurl__c" VARCHAR(765), "Fiscal_Period__c" VARCHAR(3900), "Timer_Start_Applic_Eng__c" DATE, "Timer_Start_Proposal__c" DATE, "Project__c" VARCHAR(18), "Time_with_Proposal_Eng__c" DOUBLE, "Waiting_for_cust__c" SMALLINT, "Waiting_for_supplier__c" SMALLINT, "Win_strategy__c" VARCHAR(765), "Country_cust__c" VARCHAR(765), "Reporting_label__c" VARCHAR(3900), "Rep_RecType__c" VARCHAR(3900), "OTP_Preferred__c" VARCHAR(765), "Days_with_App_Engineer__c" DOUBLE, "Proposal_Engineer__c" VARCHAR(18), "Stra__TrackingNumber__c" VARCHAR(36), "Project_On_Hold__c" SMALLINT, "Preferred__c" VARCHAR(765), "Dead_reason__c" VARCHAR(765), "With_app_engineer__c" SMALLINT, "Days_with_Estimator__c" DOUBLE, "Budget_quote__c" SMALLINT, "Project_stage__c" VARCHAR(765), "Timer_WaitForCust__c" DATE, "TimeWaitedForCust__c" DOUBLE, "Timer_Start_Stage_R1__c" DATE, "Timer_Start_stage_R2__c" DATE, "Timer_Start_Stage_R3__c" DATE, "Timer_Start_Stage_R4__c" DATE, "Timer_Start_Stage_R5__c" DATE, "Timer_Start_Stage_R6__c" DATE, "Time_in_Stage_R1__c" DOUBLE, "Time_in_Stage_R2__c" DOUBLE, "Time_in_Stage_R3__c" DOUBLE, "Time_in_Stage_R4__c" DOUBLE, "Time_in_Stage_R5__c" DOUBLE, "Time_in_Stage_R6__c" DOUBLE, "Timer_StartWaitForSupp__c" DATE, "Time_Waited_For_Supplier__c" DOUBLE, "Stage_explanation__c" VARCHAR(765), "In_strip__c" SMALLINT, "Quote_Required_Date__c" DATE, "Quote_Required_By_Date__c" DATE, "Sum_products__c" DOUBLE, "Priority_rating__c" VARCHAR(3900), "Order_to_place__c" SMALLINT, "Days_with_Proposal_Eng__c" DOUBLE, "Time_inStrip__c" DOUBLE, "timer_inStrip__c" DATE, "Days_in_strip__c" DOUBLE, "Application_Engineer__c" VARCHAR(18), "Estimator__c" VARCHAR(18), "Business_Unit__c" VARCHAR(3900))
Trying to DROP table before creating it. Table name `temp5458532393141619885`
Failed to drop table `temp5458532393141619885`
Table `temp5458532393141619885` created successfully
New job ID=75030000000MHTsAAO in Open state.
******************* Finish Time = Thu Jan 26 16:14:21 GMT 2012
************* Total time = 26110

Thanks

HTTP Connector doesn't return the http response

Anonymous — Fri, 27 Jan 2012 16:30:21 GMT

Hi I am having the same problem I just want to get the html from a webpage but the response always come empty

url: www.google.pt
method: get

response longText 105000

Thanks.

Regards

XML Connector with optional tag problem

crd — Tue, 24 Jan 2012 18:29:17 GMT

Hello,

I have some trouble using XML connector on Apatar 1.12.12 with an XML file like the following:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<root>
<Person>
<name> Test </name>
<city>London</city>
</Person>
<Person>
<name> Doe </name>
<city>Paris</city>
<firstname>John</firstname>
</Person>
</root>

When I asked for Run/Preview results on the connector configured on the tag Person, I have the following error:

Console View wrote:

The parameter position '6' is out of range. The number of parameters for this prepared statement is '5'.

In the results view, the attribute firstname is empty for the 2 lines (when it is expected to be "John" for the 2nd row) and the city of the 2nd row is "John" instead of Paris.

Results View wrote:

No---id--parentid----name------city------firstname
1-----2------1----------Test-----London
2-----5------1----------Doe------John

The cause is obviously that the optional tag firstname is not present in the first record.

My question is : how to manage this case in an automatic way (because I have a more longer XML file with a lot of empty optional tag to manage in Apatar) ?
The goal is to have a blank value when the optional tag is not used and the real value when it is used, and of course to have the good value for each attribute.

If possible I prefer to do it in Apatar but if not, I am tuned in any idea to do it in a simple way.

Regards

CRD