Element "NULL" not found in dimension errors during }src_dim_export_data

Pulse Pulse Questions
1

At a customer running PA 2.0.3 we are seeing some strange errors on dimension updates when Pulse calls the }src_dim_export processes to get the dimension outline into the git repository

The content of the error logs is always the same with TM1 complaining about a “NULL” element …

“NULL”,Data Source line (327) Error: Data procedure line (114): Element “NULL” not found in dimension “TBM Tender”
Error: Data procedure line (114): error repeats 3 times
“NULL”,Data Source line (327) Error: Data procedure line (117): Invalid key: Dimension Name: “TBM Tender”, Element Name (Key): “NULL”

The error is coming from a AttrS on the non-existing element. Looking in the }Export.All subset there is no “NULL” member in the subset for the couple of dimensions where this consistently happens.

To avoid the error but still get a notification when it happens I added the following at line 90 on the Data tab to skip if there is an invalid element.

  If( DimIx( pDimName, sEl ) = 0 );
      LogOutput('WARN', Expand('}src_dim_export_data: element %sEl% not found in dimension %pDimName%.'));
      ItemSkip;
  EndIf;

Has this come up at any other Pulse sites running PA? We never saw this before in 10.2.2 and it also doesn’t happen in the same model running on 10.2.2. Has anyone else seen phantom “NULL” elements in PA or any other ideas what might be going on?

1 Like
2

Hi @cw-ch-scott we have seen this error as well - we have installed 2.0.3 with latest pulse on our dev box.

3

Hi @cw-ch-scott, that is a weird one, must be a bug in PA as it seems to be returning an element in the subset that doesn’t exist.

@shallabh.khera, as a temp solution you can edit the the TI process @cw-ch-scott mentions. It does get overridden when Pulse restarts however.

4

Thanks @tryan - today we have got a notification for 2.0.4 - will see if I can get it downloaded by end of week and give it a try there as well.

5

We are running 2.0.4 and are experiencing the same issue.

6

Hi @brett.jeney,

What is your Pulse version?

Cheers,

Vincent

7

Hey Vincent.

5.7.7 I believe

image001.png732×520 17.9 KB

Thanks,

Brett

8

Thanks Brett,

We created a ticket for this issue, we will investigate it and work on a workaround for the next release.

Well keep you posted once we have a fix.

Cheers,

Vincent

9

Thanks. Let me know if you need anything like error log files examples etc.

Thanks,

Brett

10

Hi @brett.jeney,

We implemented @cw-ch-scott workaround (described above in the first post) and it will be part to the next release.

Cheers,

Vincent

1 Like
11

Hi,
Client use PA 2.0.3 & Pulse 5.8.0, they have similar issue with }src_dim_export_data.

The TI will have “NULL” element and return error when using DimNm to get Alias element from }ElementAttributes_dimname.

The weird thing is, the issue not always happened. As in the pic, left hand side pic runs on 1:45 am, and right hand side pic runs on 5:45 am. DIMNM return different result… and it seems to happen only on specific dimension.

image
image.png1440×716 26.6 KB

image
image.png1221×689 12.5 KB

Has anyone seen this issue after Pulse implement itemskip for NULL elements in “All” subset?

Eddie

12

Hi @echang,

This has been associated with a Bug in PAL 2.0.7. In this case DIMSIZ is the one with the error, Pulse uses this TI to get all the elements of the }ElementAttributes_dimension associated to a given dimension. For some unknown reason, DIMSIZ returns more number of elements than actually exist. By adding a condition to re-evaluate if the element exists should fix the issue(weird, but necessary in this case).

This has been included in 5.8.2.

Regards,

Erik

13

I don’t think it is only an issue with 2.0.7. We are running 2.0.8 IF6 and see a similar issue with }src_dim_export.

For some (but not all) dimensions that have alternate hierarchies enabled, whenever there is a change to these dimensions this process errors with either …

Error: Prolog procedure line (13): Hierarchy name unspecified for multi-hierarchy dimension “DimName”

or …

Error: Prolog procedure line (16): Dimension “HierName” not found

14

Hi @cw-ch-scott,

Pulse 5.8.2 considers a workaround for this situation.

Regards,

Erik

1 Like