Unable to run analyst macro in contributor.

[John 27182]

Hi Everyone,

I've built a macro which works in analyst, but not in contributor. In contributor the macro fails, and I get the following message in the error details page:

Unable to execute macro 'MyMacro'. The return code was 1107.

The macro involves updating D-Lists from text files, and I suspect that this may be the bug. But I cannot find any solution!

Any help would be appreciated.

[ericlfg]

Hi John,

What version of planning are you using?  What steps do you have in this macro in analyst? 

I've seen this occur when there are ODBC macro steps, and either the connection hasn't been coded into it, or the @ODBCConnect isn't specified.  I've also seen problems between mapped drives and UNC paths in the configuration of the location of the .txt files (or other pieces of the install, such as filesys.ini and libs.tab locations).

Maybe this will point you in the right direction:
http://www-01.ibm.com/support/docview.wss?uid=swg21392527

Cheers,

[John 27182]

Hi Eric,

You were right! I'm using Cognos 8.3 and the macro was crashing when I was opening an ODBC connection.

To solve the problem I had to recreate my connection. So when I created my system DSN file (text driver), in the “select directory” window I clicked the “Network” button. I had to map a network drive to the folder I wanted (picking “none” in the drive drop down box). Once this was done it worked.

Thanks for the help.  :)

[ericlfg]

Great news!

Glad to help.  :)