SQL Access Manager SQL Error when clicking count rows in Archive Data to history
edited Mar 29, 2014 12:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
Hi,
I am getting the SQL Access Manager SQL Error when the below steps are followed. Please let me know if anyone has this resolved already
1) Peopletools > Data Archive Manager > Archive Data to History (Create a new RC)
2) Use the below values for the parameters
Archive Template : KKACTVTY
Process Type: Selection
Selective Query: KK_ARCHIVE_ACTIVITY
Commit based processing: Set-Based Processing
3) Save the RC (Run Control) and Click Define binds
4) Enter the bind variables for the query
5) Click the Count Rows link for any Non Base Archive Object (In this case anything except KK_ARCHIVE_ACTIVITY (Archive Object)). For ex: try Count Rows adjacent to
Tagged:
0