Exception Condition Date_After_Range raised in BEx Query

[Former Member]

Hi All,

I got the above error on after executed Query 0TCT_MC01_Q0112. Anyone has any idea what is this and what actually caused it.

Your feedback is really much appreciated.

Thanks

Best Regards,

Nas

[former_member225306 · Accepted solution]

Hi,

This issue is resolved with note 1529649.

Still you have problem please check the expiring validity of the Factory Calendar.

Please check the 'Default Factory Cal' in tx RSRHIERARCHYVIRT and

also you could check the date range via tcode SCAL. T-cd: SCAL->

Factory calendar ->

Thanks,

Venkat

[sapna_jgurudutt]

Hi,

Can you please refer the following notes and check whether it helps you:

790371 - DATE_AFTER_RANGE exception when executing a query

1529649 - Factory Calendar expires 2010

Thanks & Regards,

Sapna

Edited by: Sapna J Gurudutt on Feb 10, 2012 12:28 PM

[anshu_lilhori]

Hi,

Check if this helps...

These Kind of error also may be due to Factory calender setting was not populated in BI

So Go to RSA1 -> Source System-> right click on R/3 client -> Transfer global Setting-> check factory calender and first check radio button simulation -> execute-> Tables TFACD (go to se16 and check entries in that table for country id ) -> when ur sure about entries go back and check Rebulid table instead of simulation and execute.

The new entries will get populated in BI.

Regards,

AL