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
