QS Error: The object could not be saved

Mon, 14 Sep 2015 14:06:37 GMT

Hi,

We are creating an app in QS Enterprise and are using QVD to load data. While saving the app, it fails with below error:

Started loading data

BT_CUSTOMERS

(QVD (row-based) optimized)

Lines fetched: 838,772

SALES_ORGANIZATION

(QVD (row-based) optimized)

Lines fetched: 7,319

SOURCE_SYSTEMS

(QVD (row-based) optimized)

Lines fetched: 19

TIME_PERIOD_DATE

(QVD (row-based) optimized)

Lines fetched: 220,245

PRODUCTS_DIM

(QVD (row-based) optimized)

Lines fetched: 21,496,315

INVOICE_LINES_FACT << INVOICE_LINES_CURR_YEAR

(QVD (row-based) optimized)

Lines fetched: 8,785,719

INVOICE_LINES_FACT << INVOICE_LINES_PREV_YEAR

(QVD (row-based) optimized)

Lines fetched: 18,059,868

OSO_LINES_FACT << OSO_LI_MONTH_CURR_YEAR

(QVD (row-based) optimized)

Lines fetched: 16,430,666

OSO_LINES_FACT << OSO_LI_MONTH_PREV_YEAR

(QVD (row-based) optimized)

Lines fetched: 36,627,305

QUOTE_LINES_FACT << QUOTE_LINE_ITEM_PREV_YEAR

(QVD (row-based) optimized)

Lines fetched: 30,808,951

QUOTE_LINES_FACT << QUOTE_LINE_ITEM_CURR_YEAR

(QVD (row-based) optimized)

Lines fetched: 56,073,271

$Syn 1 = %BILL_TO_CUSTOMER_SKEY+%SELLING_LOCATION_SKEY+%SSID+%TIME_PERIOD_DATE_SKEY+%PRODUCT_SKEY

The object could not be saved.

Data has not been loaded. Please correct the error and try loading again.

Can someone please point out what might be the cause and how can we troubleshoot it? Any log in particular that can help?

Server: VM - Windows 2012, 32gb RAM, 4 core, 100GB HDD (40GB free)

Thanks!

Re: QS Error: The object could not be saved

csellei — Fri, 30 Oct 2015 21:11:36 GMT

We're running into the same issue.

Did you solved it?

Regards.

Chrisitan.

Re: QS Error: The object could not be saved

JonnyPoole — Tue, 03 Nov 2015 00:59:56 GMT

the last line shows creation of a synthetic key that looks a little nasty... lots of fields.

I doubt its intentional.

You can enter:

qualify *;

...at the beginning of the load editor to ensure no links of any kind are formed during the data load. If it works then you know its due to to the synthetic key and you will have to address that in the model

topic Re: QS Error: The object could not be saved in App Development

QS Error: The object could not be saved

Re: QS Error: The object could not be saved

Re: QS Error: The object could not be saved