Hi Experts,
I have imported bulk data in new Database.
I am exporting data from the Entity - EcoResProductAttributeValueV3Staging but after taking a long time it is showing error.
Error log -
Cannot select a record in Product attribute values V3 (EcoResProductAttributeValueV3Entity).
A time-out occurred in the database while the query was executing.
Results. SELECT T1.PRODUCTNUMBER,T1.ATTRIBUTETYPENAME,T1.ATTRIBUTENAME,T1.CURRENCYCODE,T1.CURRENCYVALUE,T1.BOOLEANVALUE,T1.DATETIMEVALUE,T1.DECIMALVALUE,T1.INTEGERVALUE,T1.TEXTVALUE,T1.FLOATUNITOFMEASURE,T1.INTUNITOFMEASURE,T1.UNITOFMEASURE,T1.FLOATUNITOFMEASURESYMBOL,T1.INTUNITOFMEASURESYMBOL,T1.RECID#2,T1.RECVERSION#2,T1.RECID#3,T1.RECVERSION#3,T1.RECID#4,T1.RECVERSION#4,T1.RECID#5,T1.RECVERSION#5,T1.RECID#6,T1.RECVERSION#6,T1.RECID#7,T1.RECVERSION#7,T1.RECID#8,T1.RECVERSION#8,T1.RECID#9,T1.RECVERSION,T1.PARTITION,T1.RECID FROM ECORESPRODUCTATTRIBUTEVALUEV3ENTITY T1 WHERE (((((((((PARTITION=5637144576) AND (PARTITION#2=5637144576)) AND (PARTITION#3=5637144576)) AND (PARTITION#4=5637144576)) AND (PARTITION#5=5637144576)) AND ((PARTITION#6=5637144576) OR (PARTITION#6 IS NULL))) AND ((PARTITION#7=5637144576) OR (PARTITION#7 IS NULL))) AND ((PARTITION#8=5637144576) OR (PARTITION#8 IS NULL))) AND (PARTITION#9=5637144576)) ORDER BY T1.PRODUCTNUMBER,T1.ATTRIBUTETYPENAME,T1.ATTRIBUTENAME.
Can anyone suggest something
Check this thread for large volume of data export from data entities
HI Harish,
If there is a lot of records, best way will be adding filter to split the number of records to be exported.
This filter is similar to the Advance filter and sort option on the forms.
Refer to the below documentation for query syntax.
Thanks,
Girish S.
If the records are in lakhs, then I would suggest you to add the filter and do the export in batch.
For setting timeout, you can follow the same thing how we will do it for SSRS reports. But setting timeout with long times will actually affect the total system performance.
I haven't changed timeout settings but you can try in Data import/export framework parameters
check this article
Hi Rampal/Preetham,
The records are in lakhs.
Preetham- How to increase the timeout time.?
How many records are there in underlying table in that legal entity and are you exporting for one or all legal entities
So the issue is with data. It might have lot of data. You need to increase the timeout time or you need to give the filter and run in batch.
Hi Rampal,
Yes Facing issue when Exporting in Batch. If I export using Filter for some records. It is working fine.
Hi Preetham,
Yes I have checked and it is returning some data.
Are you facing this issue only in this data entity? Can you try export in Batch option from your data project.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156