Apr 20, 2021
12:07 AM
if I do a select like so: select complianceuserid from FNMSCompliance.dbo.ComplianceUser_MT where username = [users$].[User Name] I get "The multi-part identifier "users$.User Name" could not be bound."
... View more
Apr 20, 2021
12:01 AM
If I remove the excel tab and just put the column names I get "Invalid column name 'User Name'. Invalid column name 'Team Products'."
... View more
Apr 19, 2021
11:57 PM
If I create a business adapter with a custom query for the purpose of importing data from an excel spreadsheet into a table in the fnmsstaging database, in the custom query how do I select data from the spreadsheet? I've tried select statements but they always return "Invalid object name 'users$'." ('users' being the name of the spreadsheet tab) Does anyone have any example code showing how to do this?
... View more
Jul 15, 2020
07:05 PM
3 Kudos
Hi, just wanted to add that this issue has been identified as a bug by Flexera (bug ID: IOJ-2128316). It can be fixed by adding a line into the web.config <assemblies> section as per below <assemblies> <add assembly="DevExpress.Data.v15.1, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.Printing.v15.1.Core, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.Utils.v15.1, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.Web.ASPxTreeList.v15.1, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.Web.Mvc.v15.1, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.Web.v15.1, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> <add assembly="DevExpress.RichEdit.v15.1.Core, Version=15.1.15.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" /> – to add – <add assembly="System.Runtime, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> </assemblies> After making the update to the web.config restart IIS to load the new config
... View more
Jul 12, 2020
06:45 PM
Hi, I have exactly the same issue. Are you saying that you resolved the issue by completely removing the previous version of FNMS and also removing IIS, then carrying out a fresh installation of both?
... View more
Jan 16, 2020
03:33 PM
Ah yes , that was the problem. The scheduled tasks were disabled. All fine now.
... View more
Jan 16, 2020
02:09 PM
Thanks! I checked the uploader log and noticed it has not been updated since last November. I've checked the parent connection in the beacon GUI, which is fine, have restarted the Flexnet beacon services on the device, and also rebooted the device as a last resort but still the uploader log does not update. Any other suggestions?
... View more
Jan 15, 2020
05:53 PM
I tried this but it made no difference. Any other suggestions?
... View more
Latest posts by michael_hoogen
Subject | Views | Posted |
---|---|---|
1017 | Apr 20, 2021 12:07 AM | |
1020 | Apr 20, 2021 12:01 AM | |
1028 | Apr 19, 2021 11:57 PM | |
2101 | Jul 15, 2020 07:05 PM | |
2155 | Jul 12, 2020 06:45 PM | |
3174 | Jan 16, 2020 03:33 PM | |
3182 | Jan 16, 2020 02:09 PM | |
3198 | Jan 15, 2020 05:53 PM |
Activity Feed
- Got a Kudo for Re: Unable to access WEB UI - fresh install of FNMS 2020 R1. May 28, 2021 04:07 PM
- Posted Re: Business adapter custom queries issue. on FlexNet Manager Forum. Apr 20, 2021 12:07 AM
- Posted Re: Business adapter custom queries issue. on FlexNet Manager Forum. Apr 20, 2021 12:01 AM
- Posted Business adapter custom queries issue. on FlexNet Manager Forum. Apr 19, 2021 11:57 PM
- Got a Kudo for Re: Unable to access WEB UI - fresh install of FNMS 2020 R1. Jul 16, 2020 09:13 AM
- Kudoed Re: Unable to access WEB UI - fresh install of FNMS 2020 R1 for Kevin_Hou. Jul 15, 2020 08:24 PM
- Got a Kudo for Re: Unable to access WEB UI - fresh install of FNMS 2020 R1. Jul 15, 2020 07:09 PM
- Posted Re: Unable to access WEB UI - fresh install of FNMS 2020 R1 on FlexNet Manager Forum. Jul 15, 2020 07:05 PM
- Posted Re: Unable to access WEB UI - fresh install of FNMS 2020 R1 on FlexNet Manager Forum. Jul 12, 2020 06:45 PM
- Posted Re: Beacon Policy Status shows "Awaiting update" on FlexNet Manager Knowledge Base. Jan 16, 2020 03:33 PM
- Posted Re: Beacon Policy Status shows "Awaiting update" on FlexNet Manager Knowledge Base. Jan 16, 2020 02:09 PM
- Posted Re: Beacon Policy Status shows "Awaiting update" on FlexNet Manager Knowledge Base. Jan 15, 2020 05:53 PM