Service Operations Insight

 View Only

Tech Tip: SQL Script to find group guid fails with ora-01489 

Feb 16, 2017 12:57 PM

TECH TIP - If the above SQL statement fails with error - 'ora-01489 result of string concatenation is too long' you can potentially resolve by adding the desired group type to the where clause.

Typically this is a one of the Business Service groups or a custom group. Find this WHERE in the SQL and add an AND with the type of group you are looking to delete.

 

WHERE a.entity_type = b.entity_type_id

AND b.entity_class = 'group'

-- Add in line below, replacing 'group_type' with desired type. Example 'business_service'
AND b.entity_type = 'group_type'

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.