Some users may have issues creating a community account. For more information, please click here.

SRicky
Active participant

SAP reconciliation failure

Jump to solution

Dear all

When tried to click current license position under SAP>License Position but error occurred. having error mentioned inline

A Problem Occurred SAP>License Position: {LandscapeName} FlexNet Manager Platform detected a problem and could not complete your request.  Error SAP license position calculation failed with error message An error has occurred during SAP license position calculation: OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Consumed'

Please suggest 

Labels (1)
0 Kudos
1 Solution
JohnSorensenDK
Moderator Moderator
Moderator

@SRicky 

Although you didn't include the complete error message I did a quick search based on the error and found that something like this can happen in situations where one of the metrics in the divider of a formula is 0, e.g. Metric(5001)/Metric(5001)*2000 which fails if Metric(5001) is '0'

If you find something like that you can replace the formula with If(Metric(5001)>0, Metric(5001)/Metric(5001)*2000, 0)

Thanks,

View solution in original post

0 Kudos
1 Reply
JohnSorensenDK
Moderator Moderator
Moderator

@SRicky 

Although you didn't include the complete error message I did a quick search based on the error and found that something like this can happen in situations where one of the metrics in the divider of a formula is 0, e.g. Metric(5001)/Metric(5001)*2000 which fails if Metric(5001) is '0'

If you find something like that you can replace the formula with If(Metric(5001)>0, Metric(5001)/Metric(5001)*2000, 0)

Thanks,

View solution in original post

0 Kudos