Hi:

I continue to have issues, with this SSRS report.  I have entered five cases, here in experts-exchange, on this.

Now, I'm getting an error on the main report saying that the "Subreport could not be shown".

Last week, the subreport's data appeared just fine.  This week, it does not.

What would cause this issue?

Thanks!

John

How do I translate a cn= (either common name or cannoical name, not sure) into the actual users name so I can find out which user is causing this error

from Event Log Below:  Mapi session /o="Company Name"/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=e42d9331822a4587b26c214a3ccb4dbc with client type MoMT exceeded the maximum of 500 objects of type Folder.

How would I find which user is cn=e42d9331822a4587b26c214a3ccb4dbc  

Can be using Powershell, dsquery or any other tool / method.

Log Name:      Application
Source:        MSExchangeIS
Date:          10/4/2019 9:24:46 AM
Event ID:      9646
Task Category: MAPI
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      <SERVER NAME>
Description:
Mapi session /o="Company Name"/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=e42d9331822a4587b26c214a3ccb4dbc with client type MoMT exceeded the maximum of 500 objects of type Folder.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSExchangeIS" />
    <EventID Qualifiers="49156">9646</EventID>
    <Level>2</Level>
    <Task>6</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2019-10-04T13:24:46.000000000Z" />
    <EventRecordID>9822389</EventRecordID>
    <Channel>Application</Channel>
    <Computer>"COMPUTER NAME"</Computer>
    <Security />
  </System>
  <EventData>
    …

In SSRS, I want to filter out only those employees with more than 1 partfile number.  

My query is

Select e.name,
            p.pfnumber from employees as e
left join partfile as p
on p.recid=e.partfilerecid
group by e.name

What expression do I use in the filter to be > 1?

Good day,

I am in the process of migrating my entire network to a new domain. There is a trust relationship between the old and new domain. I have also kept usernames and group names the same as well as migrated SID across to new domain. When migrating my file server to new domain, all permissions are still intact as it was on old domain. How do I keep the permissions the same and just change the domain name from old to new, i.e. olddomain\group1 to newdomain\group1 on all folders, subfolders and files? I have SubInACL but have never used it before and don't know the commands.

Also, is it wise to migrate the SID's across to the new domain?

Lenovo TD340 server 2012, purchased in 2015, my customer needs to upgrade in place to server 2019 to continue to get support from our app vendors.
My supplier says Lenovo TD340 does not support server 2016 or 2019.

I am trying to write a SQL statement whereby I have a field named FormElementReference, which is the name of the question, and an associated field called value which holds the answer to that question.

I've written a case statement to try and achieve this, and store the separate values in separate fields for export to SSRS.

What I currently get is an row for each answer value.


SELECT DISTINCT
  FormResults.FormResultKey AS [FormResults FormResultKey]
  ,FormResults.FormID
  ,FormResults.FormReference
  ,UserForename + ' ' + UserSurname as [Full Name]
  ,FormResults.FormResultDate
 
 

,CASE WHEN FormResultDetails.FormElementReference = 'Date' then value else null end AS JobDATE
,CASE WHEN FormResultDetails.FormElementReference = 'Time' then value else null end AS TIMEFrom
,CASE WHEN FormResultDetails.FormElementReference = 'TEB' then value else null end AS TIMETo
,CASE WHEN FormResultDetails.FormElementReference = 'TEA' then value else null end AS TotalWorked
,CASE WHEN FormResultDetails.FormElementReference = 'JNO' then value else null end AS JobNumbers
,CASE WHEN FormResultDetails.FormElementReference = 'AA' then value else null end AS JobAddress
,CASE WHEN FormResultDetails.FormElementReference = 'Reason' then value else null end AS JobReason
,CASE WHEN FormResultDetails.FormElementReference = 'Managers' then value else null end AS ManagerAuthorised


FROM
  FormResultAnswers
  LEFT OUTER JOIN Documents
    ON …

I'm unable to create an OU in Active Directory, it says that an OU with that name is already in use.  I did a search for this OU at the top level of domain no results.  I created this OU last night on secondary DC it never propagated over to primary.  Came in this morning secondary DC had "Pending Status" assuming it was from the newly created OU last night,  unable to get rid of Pending status without a reboot.  Now even though OU doesn't exist it thinks it does.  How can i clear this up?

We are trying to track down an issue where the password expiration date is not conforming to our policy.  We have a 90 policy, but the password on domain accounts seem to be expiring at 42 days.  

The following net user command provides the expected output:

>net user /domain joe.user
The request will be processed at a domain controller for domain example.com.
User name                    joe.user
Full Name                    Joe User
Comment
User's comment
Country/region code          000 (System Default)
Account active               Yes
Account expires              Never

Password last set            8/1/2019 9:09:56 AM
Password expires             10/30/2019 9:09:56 AM
Password changeable          8/2/2019 9:09:56 AM
Password required            Yes
User may change password     Yes
.....

Select all Open in new window

The 10/30/2019 date corresponds with the 90 day requirement.  However, the password expires much sooner.  Using the following get-aduser command, you get a different date:

(Get-ADUser -Identity joe.user -Properties msDS-UserPasswordExpiryTimeComputed).'msDS-UserPasswordExpiryTimeComputed' |ForEach-Object -Process {[datetime]::FromFileTime($_)}

Thursday, September 12, 2019 9:09:56 AM

Select all Open in new window

The dates provided by the two commands are different.  Any insight why, it may help use narrow down the issue if we knew why the two commands return different dates?  Also, the account really does expire earlier than the 90 policy.  We've had users needing to change their password even though the net user command shows they have plenty of time.

We have a number of reports that run out of our batch system behind data loads. There have been some recent updates. Previously, we have only one account type, so the parameter was just a single-value text value. We now use a multi-select parameter, and am getting an error when we attempt to run in batch although it runs properly through the web interface. I've captured the command line from our batch system:

\\xxx.com\share\CM\DEV\OPS\Apps\SSRSReportBuild\SSRSReportBuild.exe "Report=Solutions/ZZ-XX-12345-AccountAuditReport" "FileName=FCT-ZZ-XX-12345-AccountAuditReport.rdl" "MaxRunTime=1800" "Path=\\rpt2webtest\MFTest" "pAcctType=ABC,XYZ" "pAcctTypeList=ABC,XYZ" "pRunDate=20190906" "pRunType=D" "Render_Format=EXCEL"

Select all Open in new window

When executed, the job fails with this error:

System.Web.Services.Protocols.SoapException: This report requires a default or user-defined value for the report parameter 'pAcctType'. To run or subscribe to this report, you must provide a parameter value.

Select all Open in new window

Any suggestions of how to correct this and properly pass the value for pAcctType, a multi-value parameter?

Some of the questions that might come up

• The source of available values for the multi-select parameter in the report is a SQL query.
• The values 'ABC' and 'XYZ' do exist in the data.
• We cannot pass the same parameter name twice on the command line, as the API does not allow this and will generate and error (I mention this becasue some web searching I've done indicate that is how you pass multi-select values in the web interface (e.g. &pAcctType=ABC&pAcctType=XYZ...)

I'm having trouble with my internal SMTP mail relay. A user had some malware and we were flagged as spammers. Now SSRS email does not work. I have loads of stuff that uses the internal mail relay but am slowly going through and changing things but am stuck on SSRS

The only options I have within SSRS Config Manager are :

Sender Address:
Current SMTP Method: (set to 'Use SMTP Server' but greyed out)
SMTP Server: (This has IP address of internal mail relay)

Does anyone know how to get this to work with an external SMTP server?

repadmin-output.txtDestination server is currently rejecting replication requests.  Mixed OS DC environment.  Destination server is 2008 R2 and was originally the certificate store.  Attempted to move Store to a 2012 server.  after removing Store, we went for DCpromo, but the process would not complete.  We restored the Store to original location, but are experiencing multiple cert failures.  Please Help!  I'm pretty sure I did something wrong with the Certificate server, but don't know where to start.

Volume Shadow copy tab is missing in windows 2019 when drive is formatted in ReFS format.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/55d1eadd-f87c-4ba8-9c24-28b945082e60/shadow-copies-tab-is-missing-from-refs-on-windows-server-2012?forum=winserverfiles

Though as per this link all the required features are supported:
https://c-nergy.be/blog/?p=13015

ReFS: https://docs.microsoft.com/en-us/windows-server/storage/refs/refs-overview 
 

I am trying to see if I can get rid of our on prem AD server.  We have a subscription for Azure active directory P1.  It seems like I can connect everybody in the organization to that active directory and then set policies from the portal. For our file server I can simply use SharePoint. Is there any reason I would need to keep an on prem server since I’m not really using it for more than that.  I am using it as a  DHCP server and DNS server. But I can simply have our sonic wall do all that.