Command failed with error 16412: ‘FieldPath field names may not contain ‘.‘.‘ on server 10.21.20.8:2

  1. 问题描述
    查询接口报错:
{"errorMessage":
"Command failed with error 16412: 'FieldPath field names may not contain '.'.' on server 10.21.20.8:27019. The full response is { \"ok\" : 0.0, \"errmsg\" : \"FieldPath field names may not contain '.'.\", \"code\" : 16412, \"codeName\" : \"Location16412\" }"}


com.mongodb.MongoCommandException: Command failed with error 16412: 'FieldPath field names may not contain '.'.' on server 10.21.20.8:27019. The full response is { "ok" : 0.0, "errmsg" : "FieldPath field names may not contain '.'.", "code" : 16412, "codeName" : "Location16412" }
    at com.mongodb.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:115)
    at com.mongodb.connection.CommandProtocol.execute(CommandProtocol.java:114)
    at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:168)
    at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:289)
    at com.mongodb.connection.DefaultServerConnection.command(DefaultServerConnection.java:176)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:216)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:207)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:113)
    at com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:257)
    at com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:253)
    at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:435)
    at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:408)
    at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:253)
    at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:67)
    at com.mongodb.Mongo.execute(Mongo.java:836)
    at com.mongodb.Mongo$2.execute(Mongo.java:823)
    at com.mongodb.DBCollection.aggregate(DBCollection.java:1455)
    at com.mongodb.DBCollection.aggregate(DBCollection.java:1418)
    at com.mongodb.DBCollection.aggregate(DBCollection.java:1403)
    at com.linkus.biz.prj.service.impl.PrjDevTaskStatServiceImpl.getPrjDevTaskStatData(PrjDevTaskStatServiceImpl.java:127)

  1. 问题解决
    检查group中的字段,分组字段错误,group中的resp的value"joinBiz.resp"改为"resp"
"$group":{
	"_id":{
		"prjSys":"$prjSys",
		"prjMod":"$prjMod",
		"resp":"$_joinBiz_.resp",
	},
	"devTasksCount":{
		"$sum":1
	},
	"minPlanEndDate":{
		"$min":"$_joinBiz_.planEndDate"
	},
	"maxPlanEndData":{
		"$max":"$_joinBiz_.planEndDate"
	},
	"planCompletionCount":{
		"$sum":"$planCompletionNum"
	},
	"actualCompletionCount":{
		"$sum":"$actualCompletionNum"
	}      
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值