Home → Bug Reports →

Bulk Change phantom page

• Edit

espanae

18 Aug, 2015 07:21 PM

Hi,
A page asset that doesn't exist, appears in the Bulk Change tool list. While we have a base asset called "News Story" it's located somewhere else. I've noticed it in other folders but not all folders.

Is this a known issue?
Thanks.

Cascade Server 7.12.4

• bulk-change-phantom-News_Story.gif 4.5 MB

1. Support Staff 1 Posted by Tim on 18 Aug, 2015 07:29 PM

   

   Hi there,

   Let's see if we can get some more information about that asset that is appearing there. When you have a moment, can you or your DBA execute the following query and attach the results here?:
   

   select id, name, cachePath, isCurrentVersion, isWorkingCopy, isRecycled from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'
   

   Thanks!
   • Edit

2. 2 Posted by shopmyes on 19 Aug, 2015 02:42 PM

   

   +----------------------------------+------------+---------------------------------+------------------+---------------+------------+
   | id                               | name       | cachePath                       | isCurrentVersion | isWorkingCopy | isRecycled |
   +----------------------------------+------------+---------------------------------+------------------+---------------+------------+
   | b07fe6b9956aa0783236eb661037f6cb | News Story | news/stories/2015/06/News Story |                0 |             0 |          0 |
   +----------------------------------+------------+---------------------------------+------------------+---------------+------------+
   1 row in set (0.00 sec)
   

   • Edit

3. Support Staff 3 Posted by Tim on 19 Aug, 2015 02:57 PM

   

   Interesting. OK, I guess at this point I'll need to see some of the other fields since I wasn't expecting that output. Can you run this instead?:
   

   select * from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'
   

   Sorry for not having you run that the first time. I was just trying to make the output more easy to read by having the main columns I was interested in being outputted.

   I'd also like for you to run this query:
   

   select * from cxml_foldercontent where nextVersionId = 'b07fe6b9956aa0783236eb661037f6cb' or prevVersionId = 'b07fe6b9956aa0783236eb661037f6cb'
   

   and let us know the results.

   Thanks!

   • Edit

4. 4 Posted by shopmyes on 19 Aug, 2015 03:15 PM

   

   This one looks way uglier ;)

   +-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
   
   | assetType | id                               | name       | cachePath
                     | parentFolderId                   | metadataId
               | lockId | relativeOrder | isRecycled | permissionsId |
   metadataSetId | displayName | author | title
           | keywords | summary | teaser
                           | description | startDate     | endDate |
   reviewDate | expirationFolderId | expirationNoticeSent |
   firstExpirationWarningSent | secondExpirationWarningSent | workflowId |
   workflowComment | isCurrentVersion | nextVersionId | prevVersionId |
   versionDate | originalCopyId | workingCopyId | isWorkingCopy |
   lastDatePublished | shouldBePublished | lastPublishedBy | shouldBeIndexed |
   xmlId | blockType | blockIndexedFolderId | blockDepthOfIndex |
   blockIndexTypesBitmask | blockIndexContentBitmask | blockIndexOtherBitmask
   | blockSortOption | blockMaxRenderedEntities | blockFeedURL |
   blockIncludePageXML | maintainAbsoluteLinks | fileBlobId |
   fileRewriteFileContents | folderPublishMergeFolderId | folderIsRoot |
   structuredDataId                 | structuredDataDefinitionId |
   pageConfigurationSetId | pageStructuredDataVersion | templateTargetId |
   templateStylesheetId | symlinkLink | referenceBlockId | referenceFileId |
   referenceFolderId | referencePageId | referenceStylesheetId |
   referenceSymlinkId | referenceTemplateId | recycleRecordId | byteLength |
   draftOriginalId                  | draftUserId | contentTypeId |
   blockIndexedContentTypeId | blockSortOrder | indexBlockType | siteId
                       | folderWorkflowInheritDefs | folderWorkflowRequire |
   blockTwitterAccountName | blockTwitterSearchString | blockTwitterQueryType
   | blockTwitterDefaultStyle | blockTwitterExcludeJquery |
   draftAssetFactoryId              |
   
   +-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
   
   | PAG       | b07fe6b9956aa0783236eb661037f6cb | News Story |
   news/stories/2015/06/News Story | a04f945c956aa0783236eb66e61548d4 |
   b07fe6b9956aa0783236eb66bf471b10 | NULL   |     234881024 |          0 |
   NULL          | NULL          |             |        | Union College and
   the Lincoln Assassination |          |         | Profound and Pognant:
   Union College Connection to the Civil War Era |             | 1434945600000
   |    NULL |       NULL | NULL               |                    0 |
                     0 |                           0 | NULL       |
         |                0 | NULL          | NULL          |        NULL |
   NULL           | NULL          |             0 |              NULL |
             1 | NULL            |               1 | NULL  | NULL      | NULL
                   |              NULL |             2147483647 |
     2147483647 |                      0 |               1 |
         0 | NULL         |                   0 |                     0 | NULL
         |                    NULL | NULL                       |            0
   | b0810a75956aa0783236eb66921741f0 | NULL                       | NULL
                 |                         2 | NULL             | NULL
           | NULL        | NULL             | NULL            | NULL
       | NULL            | NULL                  | NULL               | NULL
                 | NULL            |          0 |
   b07fe6b9956aa0783236eb661037f6cb | georgek     | NULL          | NULL
                   |              1 | NULL           |
   3999f49e956aa05200c85bbb4fad5038 |                         1 |
           1 | NULL                    | NULL                     | NULL
               |                        0 |                         0 |
   856a06fc956aa0520003c37ee3ea4e35 |
   
   +-----------+----------------------------------+------------+---------------------------------+----------------------------------+----------------------------------+--------+---------------+------------+---------------+---------------+-------------+--------+---------------------------------------------+----------+---------+---------------------------------------------------------------------+-------------+---------------+---------+------------+--------------------+----------------------+----------------------------+-----------------------------+------------+-----------------+------------------+---------------+---------------+-------------+----------------+---------------+---------------+-------------------+-------------------+-----------------+-----------------+-------+-----------+----------------------+-------------------+------------------------+--------------------------+------------------------+-----------------+--------------------------+--------------+---------------------+-----------------------+------------+-------------------------+----------------------------+--------------+----------------------------------+----------------------------+------------------------+---------------------------+------------------+----------------------+-------------+------------------+-----------------+-------------------+-----------------+-----------------------+--------------------+---------------------+-----------------+------------+----------------------------------+-------------+---------------+---------------------------+----------------+----------------+----------------------------------+---------------------------+-----------------------+-------------------------+--------------------------+-----------------------+--------------------------+---------------------------+----------------------------------+
   
   1 row in set (0.01 sec)
   

   And the second query returned no results.

   Shawn Shopmyer

   Systems Administrator

   Union College

   Schenectady, NY 12308

   phone: 518.388.6312

   email: [email blocked]

   • Edit

5. Support Staff 5 Posted by Tim on 19 Aug, 2015 03:20 PM

   

   Ha, that's what I was afraid of. Maybe try the \G option at the end of the query?:
   

   select * from cxml_foldercontent where cachePath = 'news/stories/2015/06/News Story'\G
   

   • Edit

6. 6 Posted by shopmyes on 19 Aug, 2015 03:26 PM

   

   You're my new best friend, that's fantastic:

   *************************** 1. row ***************************

                     assetType: PAG

                            id: b07fe6b9956aa0783236eb661037f6cb

                          name: News Story

                     cachePath: news/stories/2015/06/News Story

                parentFolderId: a04f945c956aa0783236eb66e61548d4

                    metadataId: b07fe6b9956aa0783236eb66bf471b10

                        lockId: NULL

                 relativeOrder: 234881024

                    isRecycled: 0

                 permissionsId: NULL

                 metadataSetId: NULL

                   displayName:

                        author:

                         title: Union College and the Lincoln Assassination

                      keywords:

                       summary:

                        teaser: Profound and Pognant: Union College Connection
   to the Civil War Era

                   description:

                     startDate: 1434945600000

                       endDate: NULL

                    reviewDate: NULL

            expirationFolderId: NULL

          expirationNoticeSent: 0

    firstExpirationWarningSent: 0

   secondExpirationWarningSent: 0

                    workflowId: NULL

               workflowComment:

              isCurrentVersion: 0

                 nextVersionId: NULL

                 prevVersionId: NULL

                   versionDate: NULL

                originalCopyId: NULL

                 workingCopyId: NULL

                 isWorkingCopy: 0

             lastDatePublished: NULL

             shouldBePublished: 1

               lastPublishedBy: NULL

               shouldBeIndexed: 1

                         xmlId: NULL

                     blockType: NULL

          blockIndexedFolderId: NULL

             blockDepthOfIndex: NULL

        blockIndexTypesBitmask: 2147483647

      blockIndexContentBitmask: 2147483647

        blockIndexOtherBitmask: 0

               blockSortOption: 1

      blockMaxRenderedEntities: 0

                  blockFeedURL: NULL

           blockIncludePageXML: 0

         maintainAbsoluteLinks: 0

                    fileBlobId: NULL

       fileRewriteFileContents: NULL

    folderPublishMergeFolderId: NULL

                  folderIsRoot: 0

              structuredDataId: b0810a75956aa0783236eb66921741f0

    structuredDataDefinitionId: NULL

        pageConfigurationSetId: NULL

     pageStructuredDataVersion: 2

              templateTargetId: NULL

          templateStylesheetId: NULL

                   symlinkLink: NULL

              referenceBlockId: NULL

               referenceFileId: NULL

             referenceFolderId: NULL

               referencePageId: NULL

         referenceStylesheetId: NULL

            referenceSymlinkId: NULL

           referenceTemplateId: NULL

               recycleRecordId: NULL

                    byteLength: 0

               draftOriginalId: b07fe6b9956aa0783236eb661037f6cb

                   draftUserId: georgek

                 contentTypeId: NULL

     blockIndexedContentTypeId: NULL

                blockSortOrder: 1

                indexBlockType: NULL

                        siteId: 3999f49e956aa05200c85bbb4fad5038

     folderWorkflowInheritDefs: 1

         folderWorkflowRequire: 1

       blockTwitterAccountName: NULL

      blockTwitterSearchString: NULL

         blockTwitterQueryType: NULL

      blockTwitterDefaultStyle: 0

     blockTwitterExcludeJquery: 0

           draftAssetFactoryId: 856a06fc956aa0520003c37ee3ea4e35

   1 row in set (0.00 sec)

   ERROR:

   No query specified

   I don't know why I got the error at the end though.

   Shawn Shopmyer

   Systems Administrator

   Union College

   Schenectady, NY 12308

   phone: 518.388.6312

   email: [email blocked]

   • Edit

7. Support Staff 7 Posted by Tim on 19 Aug, 2015 03:36 PM

   

   Awesome. Thanks, Shawn! OK, it looks like that particular Page is a Draft from the user georgek. Drafts shouldn't be appearing in that interface, so I'm filing a bug report to have us address this. I'll attach it to this issue shortly.

   In the meantime, you can simply ignore that asset (by unchecking it prior to performing your Bulk Change) - or - you can have that User delete the Draft or merge the changes into the current version.

   • Edit

8. Support Staff 8 Posted by Tim on 19 Aug, 2015 03:39 PM

   

   OK, I went ahead and filed an issue for this which I've attached to this ticket. You'll see it on the right-hand side of the discussion with a state of 'open'. When we have addressed the issue, that state will change to 'closed' or 'resolved'. At that point you can keep an eye out on our Release Notes for any new versions we make available to see if that bug fix was added.

   Thanks for the report and let me know if you all have any additional questions!

   • Edit

9. 9 Posted by espanae on 19 Aug, 2015 03:52 PM

   

   Thank you, Tim and Shawn, for helping me troubleshoot this. I'll look for the fix in an upcoming release and let georgek know about his draft in the meantime.

   Erik

   • Edit

10. espanae closed this discussion on 19 Aug, 2015 03:53 PM.