Revisions to A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM"

replaced http://stackoverflow.com/ with https://stackoverflow.com/

Source Link

edited May 23, 2017 at 12:37

1

I am trying to figure out an error we are seeing when using core service to create a folder or any item (basic operations)...

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011, but I don't think in that post they are using core service.

I also receive this error when migrating with Content Porter 8.

Seems like it could be a product defect, since we are just hitting API. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 API) ?

I am trying to figure out an error we are seeing when using core service to create a folder or any item (basic operations)...

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011, but I don't think in that post they are using core service.

I also receive this error when migrating with Content Porter 8.

Seems like it could be a product defect, since we are just hitting API. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 API) ?

I am trying to figure out an error we are seeing when using core service to create a folder or any item (basic operations)...

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011, but I don't think in that post they are using core service.

I also receive this error when migrating with Content Porter 8.

Seems like it could be a product defect, since we are just hitting API. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 API) ?

added 2 characters in body

Source Link

edited May 3, 2017 at 12:54

Marko Milic ♦

8.9k
3
24
60

I am trying to figure out an error we are seeing when using coreservicescore service to create a folder or any item (basic operations)...

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011.., but I dontdon't think in that post they are using coreservicescore service.

I also recievereceive this error when migrating with Content Porter 8.

Seems like it could be a product defect, since we are just hitting apiAPI. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 apiAPI) ?

I am trying to figure out an error we are seeing when using coreservices to create a folder or any item (basic operations)..

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011.. but I dont think in that post they are using coreservices.

I also recieve this error when migrating with Content Porter 8

Seems like it could be a product defect, since we are just hitting api. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 api) ?

I am trying to figure out an error we are seeing when using core service to create a folder or any item (basic operations)...

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011, but I don't think in that post they are using core service.

I also receive this error when migrating with Content Porter 8.

Seems like it could be a product defect, since we are just hitting API. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 API) ?

added 1 character in body

Source Link

edited Apr 24, 2017 at 15:05

Andy Ross

2.2k
12
19

I am trying to figure out an error we are seeing when using coreservices to create a folder or any item (basic operations)..

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011.. but I dont think in that post they are using coreservices.

As far as I know it was working fine with 2013; does anyone know if it was indeed resolved with Web 8.1.1 release as well?

I also recieve this error when migrating with Content Porter.

I also recieve this error when migrating with Content Porter 8

Seems like it could be a product defect, since we are just hitting api. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 api) ?

I am trying to figure out an error we are seeing when using coreservices to create a folder or any item (basic operations)..

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011.. but I dont think in that post they are using coreservices.

As far as I know it was working fine with 2013; does anyone know if it was indeed resolved with Web 8.1.1 release as well?

I also recieve this error when migrating with Content Porter.

Seems like it could be a product defect, since we are just hitting api. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 api) ?

I am trying to figure out an error we are seeing when using coreservices to create a folder or any item (basic operations)..

 A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM".
 ORA-01000: maximum open cursors exceeded
 ORA-06512: at "TCMDBUSER.EDA_TRUSTEES", line 1267
 ORA-06512: at line 1

I have viewed this Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded and it says its a known defect with Tridion 2011.. but I dont think in that post they are using coreservices.

I also recieve this error when migrating with Content Porter 8

Seems like it could be a product defect, since we are just hitting api. Even if we increase cursors, it will just mask the issue, right?

UPDATE

It is worth mentioning that we are still leveraging CoreService2013 within a mixed mode environment CMS = Web 8.1.1 & CD = 2013 SP1 HR1.

I wonder since these are basic operations within cms db and that is web 8; we should be using CoreService2015 (web 8 api) ?

update

Source Link

edited Apr 24, 2017 at 13:57

Andy Ross

2.2k
12
19

Loading

Tweeted twitter.com/StackTridion/status/855817326624722944

occurred Apr 22, 2017 at 16:15

added 19 characters in body

Source Link

edited Apr 21, 2017 at 17:43

Andy Ross

2.2k
12
19

Loading

added 65 characters in body

Source Link

edited Apr 21, 2017 at 17:30

Andy Ross

2.2k
12
19

Loading

added 152 characters in body; edited tags

Source Link

edited Apr 21, 2017 at 16:05

Andy Ross

2.2k
12
19

Loading

added 60 characters in body

Source Link

edited Apr 21, 2017 at 15:21

Andy Ross

2.2k
12
19

Loading

Source Link

asked Apr 21, 2017 at 15:10

Andy Ross

2.2k
12
19

Loading

Stack Exchange Network

Return to Question