All Questions
17 questions
5
votes
2
answers
370
views
Clean the ghost published records
We found more than 15,000 records in table dbo.ITEMS, at broker DB, which belongs to around 10 publications. But the records related component already be deleted from CMS long time ago. So there is no ...
- 1,060
3
votes
1
answer
369
views
Multiple publishes failing with while executing Stored Procedure "EDA_ITEMS_GETPUBLISHITEMS"
We have a - typically intermittent but becoming more common - issue with Tridion publishing. The error appears to be around resolving items and that a stored procedure, EDA_ITEMS_GETPUBLISHITEMS is ...
- 1,441
6
votes
2
answers
261
views
Database Permissions Required in SQL Server for Tridion Users
Do I need to give sys_admin privilege to any users in the database?
It does not seems to be required, please suggest.
Also, apart from the MTSUser (COM user), is there any other user for which I ...
- 1,690
2
votes
1
answer
440
views
Deployment Prepare Commit Phase after restore of CM and Broker databases
After restoring the CM and Broker databases from our production environment any publish action fails with the following:
Phase: Deployment Prepare Commit Phase failed, Unable to prepare
...
- 6,698
4
votes
1
answer
60
views
Clear-down UGC databases
After some initial tests to make sure everything was OK with a UGC installation I want to clear down all test comments/rating/stats before we hand it over.
Is there a "supported" way to does this ...
- 6,698
5
votes
1
answer
393
views
Configuring Content manager to use new database running in different machine
Currently we have both Tridion and Content Manager database running on same machine.
We have a plan of creating a new database on another machine and linking the current Tridion CM to use new ...
- 2,051
2
votes
1
answer
269
views
How do I change the publish state of a page to unpublish state in a structure group recursively
I have raised this question but I want to more specific and explain the complete situation.
There are many pages say around 3000.
There are many publication targets. Each developer has a target ...
- 2,051
3
votes
1
answer
271
views
Database error while saving the page
I am facing some database error while saving the page. I am using SDL Tridion 2011 Sp1 version and using Oracle Database 6.1.0.996.
Unable to save Page (tcm:202-12456-64).
ORA-01013: user requested ...
- 2,051
5
votes
1
answer
160
views
How to take Tridion CM data base back up
I am planning to take content manager Tridion_CM database backup.
I am using SDL Tridion 2011 SP1 and my database is MS SQL.
Can some one point me the links to do it.
- 2,051
3
votes
1
answer
465
views
Problem saving new TBB - Exact fetch returns more than requested number of rows
I'm having some problems in an SDL Tridion 2011 Sp 1-2 environment using an oracle DB.
I can open, edit and save all item types, except for template building blocks. When doing so the following ...
- 14.3k
9
votes
4
answers
443
views
Cannot delete publication error: The transaction log for database 'tridion_cm' is full
While trying to delete an old publication, I get the error:
The transaction log for database 'tridion_cm' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc ...
- 16.4k
5
votes
1
answer
109
views
Database permissions for DB User in cd_storage_config.xml
In an SDL Tridion 2011 SP1 HR1 implementation, what are the minimum/recommended rights that the #DB_USER# must have. In the documentation (login required) I can see
the name of a user who can ...
- 9,552
5
votes
2
answers
184
views
Tridion 2011 SP1 Recommended Oracle Patch Set Update
Loving this move to StackExchange! I have a question that's probably better suited for Support. But I haven't received a response to my ticket yet, so I'll give it a go here.
I'm getting a new ...
- 53
19
votes
1
answer
514
views
explanation of QUEUE_CONSUMERS and QUEUE_FILTERS tables
Aside from these blog postings: http://yatb.mitza.net/2012/10/slow-db-performance-on-content-manager.html and http://www.mrgn.co/2012/10/tridion-error-unable-to-notify-server/ I can't find details on ...
- 1,160
4
votes
2
answers
134
views
Getting a database error when publishing a DCP
I have been trying to publish a Dynamic Component Presentation but for some reason it keeps on failing with the following error:
A database error occurred while executing Stored Procedure
"...
- 1,485
5
votes
1
answer
426
views
Cannot insert the value NULL into column error
We keep getting the below error repeatedly in the production environment of our application.
Error: No data found. [ETA_ITEMS, U]
Cannot insert the value NULL into column 'ITEM_ID', table '...
- 861
11
votes
2
answers
197
views
Workflow Process Histories
In the database, there is a table WFL_PROCESS_HISTORIES - Does the part of the Purge Tool to clear the workflow process histories simply clear down this table, or are other changes made to the ...
- 583