Data sample creation not yet complete for table "tablen

kris18 · Post by **kris18** » Tue May 29, 2007 9:12 am

hello mates,

am getting the following error when i tried to do table analysis. i did my column analysis and revieved it but when i tried to do table analysis it is poppin the error message as follows.

"Data sample creation not yet complete for table "tablename", Please try again later "

any ideas why am getting this error.

thanks
kris

ray.wurlod · Post by **ray.wurlod** » Tue May 29, 2007 2:31 pm

Have you checked the "have reviewed this step" box?
ProfileStage does not permit you to advance to the next step until you have told it that you've reviewed the results of the prior step.

kris18 · Post by **kris18** » Tue May 29, 2007 2:45 pm

thanks for reply Ray.
yes i did check the "checkbox"(REVIEW COMPLETE FOR TABLENAME). i did column analysis and reviewed it by checking the box at left corner in the review pop up window.then next when i tried to do table analysis it is poping up this error message.

thank you

kris

cundyp · Post by **cundyp** » Thu May 31, 2007 12:45 pm

The following messages are displayed when profiling (Column Analysis) db2 tables over 350k rows.

"Data sample creation not yet complete for table "tablename", Please try again later "

or "The requested data is empty".

The first step in CA results in creating the check box and at that point the table can be
checked as revewied. The View Sample creation process can still be running and won't let you
start TA.

The second step (View Sample) in CA is to select the source table again and populate the psdb,
columndatasample table. If no rows are inserted into the columndatasample table you
know that the view sample process is not working and will hang forever.

We are working this issue with IBM and have been for a while.
(PS 7.52 bld24, unix aix, oracle psdb, DataDirect Drivers))
Pete

kris18 · Post by **kris18** » Thu May 31, 2007 2:54 pm

Thanks pete for the info.