Error in Cognos Export Utility(Content Administration)

[Arghya]

I am getting the error "CNC-BAL-0509 - One or more errors have occurred. Your request could not be fully processed" at the final step of execution of Cognos export utility using Content Administration. The Cognos Version is 10.1.1. Please help to resolve the issue. Also, please let me know how I can see the full error log for this export wizard.

Thanks,
Arghya Saha

[MFGF]

I am getting the error "CNC-BAL-0509 - One or more errors have occurred. Your request could not be fully processed" at the final step of execution of Cognos export utility using Content Administration. The Cognos Version is 10.1.1. Please help to resolve the issue. Also, please let me know how I can see the full error log for this export wizard.

Thanks,
Arghya Saha

Hi,

CNC-BAL-0509 is a generic error pointing to an issue with the notification store - usually it means you have a mis-configuration somewhere. You might find more details if you look in cogserver.log?

Take a look at the following technote for ideas on where to look.

http://www-01.ibm.com/support/docview.wss?uid=swg21627816

Cheers!

MF.

[Arghya]

Dear MFGF,

Thanks for your suggestion, I found some details in cogserver.log for today but could not identify exactly where the issue is.
Can you kindly help?
I have attached the log file.

Thanks,
Arghya

[MFGF]

Dear MFGF,

Thanks for your suggestion, I found some details in cogserver.log for today but could not identify exactly where the issue is.
Can you kindly help?
I have attached the log file.

Thanks,
Arghya

I can't see anything other than the "CNC-BAL-0509 One or more errors have occurred. Your request could not be fully processed." error in the log. I'd start looking at the suggestions in the technote as a next step.

Cheers!

MF.

[Arghya]

Hi MFGF,

Today I was trying to restart the Cognos services and found the following warning on Notification store database :

[Validate database connection properties.]
[ ERROR ] The user does not have the necessary privileges to create tables.
The transaction log for database 'FalconNotification' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases[/b]

Is this the reason of CNC-BAL-0509 issue by any chance?
Also I can see that, I am able to view the reports from the server, but not able to save any of them and the same error is thrown
"CNC-BAL-0509 - One or more errors have occurred. Your request could not be fully processed"

Thanks,
Arghya

[MFGF]

Hi MFGF,

Today I was trying to restart the Cognos services and found the following warning on Notification store database :

[Validate database connection properties.]
[ ERROR ] The user does not have the necessary privileges to create tables.
The transaction log for database 'FalconNotification' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases[/b]

Is this the reason of CNC-BAL-0509 issue by any chance?
Also I can see that, I am able to view the reports from the server, but not able to save any of them and the same error is thrown
"CNC-BAL-0509 - One or more errors have occurred. Your request could not be fully processed"

Thanks,
Arghya

This looks like it could be the culprit, yes. What database are you using? SQL Server? Oracle? I'd be looking at investigating why the transaction log isn't being cleared down...

Cheers!

MF.

[Arghya]

Hi MFGF,

We are using Microsoft SQL Server database for content store.
I am attaching the latest cogserver.log.

Thanks,
Arghya

[MFGF]

Hi MFGF,

We are using Microsoft SQL Server database for content store.
I am attaching the latest cogserver.log.

Thanks,
Arghya

This doesn't look like a Cognos issue - the transaction log of your database is full. You need to be looking at the SQL Server database to see why it isn't clearing down its transaction logs...

MF.

[RubenvdLinden]

I suspect the backup of the transaction log has failed for quite some time now. The transaction log is truncated after a successful backup.

[Arghya]

Hi RubenvdLinden,

I was thinking of increasing the size of the SQL server notification database log file by increasing the value of LOGFILSIZ tomorrow.
Do you think any other action is needed to close this issue?

Regards,
Arghya

[Arghya]

Thanks All.
This issue has been resolved by taking the Notification Store database backup with 'Truncate Log' option, which actually reduces the size of the log.

Regards,
Arghya