General Custom DataBase Error

[sathishkumar_go]

Hi

When I am reloading the QVW Application, I get this type of error

The Source Document was NOT reloaded successfully. DocumentPath=D:\QV-Project\Qvd Generator File\Production\SalesPipeline\SalesPipeline_View.qvw. Errors: 1 ScriptError: , ScriptErrorList: General Custom Database Error
, ScriptErrorDetails=
Reload failed.
The task "Sales Pipeline QVD Generator/SalesPipeline_View.qvw" failed. ErrorCount=2

Any Idea???

-Sathish

[vgutkovsky]

Sathish,

You need to be a lot more specific. At what point in the script process does that error get thrown? If it's at the very beginning then you probably have a syntax error in your connection string or something else basic like that. If it's not in the beginning, then it could be due to a load that's too heavy (like a join over millions over records). Take a look at the log file for more details (and make sure you are generating one in Document Properties).

Regards,

[sathishkumar_go]

Hi Vlad,

Ya In log file shows, it fetching 7001 rows. Every time whenever I reload this application it fetches 7001 rows only after that it gives error for CUSTOM ODBC CONNECTION FAILED.

I Checked connection string, its working fine however same connection string other table r loaded succesfully.

Looking forward ur help???

-Sathish

[vgutkovsky]

Interesting--so the error is that the ODBC connection is failing. That says a lot, because you know it's not a syntax problem but is almost definitely related to performance. Does your database have logging enabled? Check there and see if maybe you reached some kind of cap. That might actually be the problem since it's failing exactly at 7,000 rows.

Regards,

[sathishkumar_go]

Hi Vlad,

Its Really Very Interesting because In the table dates have 1998 - 2010 years. so I tried limited rows 7000 its working fine. In qvd I ll get the data 1998-2001.

after that I tried using year(FKDAT) > 2008 ITS Failed

and I tried lot of combination after that I came to know its pulling upto 2001 year. After that Example year(FKDAT) > 2001 ITS NOT WORKING?

Any Clue??? I am really need ur help!!!!!!!!

Regards

Sathish

[vgutkovsky]

I really have no idea, other than it's a DB issue. Did you take a look at the DB's log files to track what is happening during that read? Maybe something changed after 2001 with the way the fields are stored (how many bits) or what they are called...if you have a DB Admin I suggest you talk to them to work on this problem together.

Regards,