topic Re: Data has not loaded. Please correct the error. But it doesn't say what the error is? How can I fix this? in Connectivity & Data Prep

Data has not loaded. Please correct the error. But it doesn't say what the error is? How can I fix this?

Wed, 31 May 2017 18:49:11 GMT

Hi,

I was able to connect to our data warehouse.

The scree screen said that it connected to the view and fetched over 3 million lines. But then it said " The object could not be saved."

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

I don’t know what the error is.

The view is very, very large since it goes back to 2011 so I put the following where close at the end of the load script:

FROM unmmgdss.qcpi."cern_sched_fct_vw"

Where [appt_date_key] >20150101;

Thanks for any help.

Diane

kaushiknsolanki — Wed, 31 May 2017 19:03:18 GMT

Hi,

Make sure that you have sufficient RAM to hold that data.

While reload going on check your RAM status.

Regards,

Kaushik Solanki

dwforest — Wed, 14 Jun 2017 21:48:47 GMT

Is app_date_key numeric or a string? If string, then should have quotes.

Sometimes its helpful to test SQL in the database's client tool if you can; it may report errors more clearly.